This formula =GETPIVOTDATA("TheoWin",$A$72,"Player Name",+A66) works nicely to retrieve the grand total for a specific player in my list by pasting a copy of the player's name in A66.
I'd like to combined the results of a group of players from the table. Not all players want to be named, so they're coded with the REFUSED name. We have ONE REFUSED and TWO REFUSED and so on. A wild card reference in a SUMIF would simply be "*REFUSED".
I tried inserting an asterisk around REFUSED so that GETPIVOTDATA can sum all of the REFUSED but get only #REF! as a result. Is there a way to concatenate wild cards into the formula?