You can do it like this:

=SUMPRODUCT((ISNUMBER(SEARCH(G15,$B$4:$B$15)))*($C$3:$E$3=G16)*(C4:E15>0))

Hope this helps.

Pete