Wildcard in sumproduct.xlsx
I'm wondering if I do a sumif(s) or sumproduct like in the attached, can I enter something in cell H2 that will act as a wildcard for returning all of the possible data selections in Cat A (Col A).
E.g. Column A has yes/no entries and you want to be able to sum all the yes's, all the no's and all of them regardless of yes/no.
Wondering if there a symbol like a * which tells the formula to include all the results?
Bookmarks