Getting irritated that hacks that work with some formulas won't work with others.

case in point:
I can use "*"&A1&"*" to find a substring with SUMIFS, but not SUMPRODUCT.

with SUMPRODUCT:
this works: SUMPRODUCT(($B$4:$B$15=G15)*($C$3:$E$3=G16)*(C4:E15>0))
but not this: SUMPRODUCT(($B$4:$B$15="*"&G15&"*")*($C$3:$E$3=G16)*(C4:E15>0))

Please help if you can!

Thank you!