wildcard in sumif(s) or sumproduct

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?

Try

=SUMPRODUCT(((Table_Data[Cat A]=H2)+(H2="")>0)*(Table_Data[Cat B]=H3)*(INDEX(Table_Data,,MATCH(H4,Table_Data[#Headers],0))))

That works
what's the logic there for understanding please

It's basically an OR

((Table_Data[Cat A]=H2)+(H2="")>0)*

There's 2 criteria
Is Cat A = H2 ?
Is H2 "" ?

Each with a True or False answer.
True = 1, False = 0
So the result of each is added, and that sum could be either 0 1 or 2

Then the >0 tests if that result is greater than 0 (1 or 2)
So the >0 part can only be TRUE if Either or Both of the criteria are TRUE.
It will be False if both criteria are false.

Brill cheers for the help

You're welcome.