Counting cells with numbers in the column that contains specific words

I had no idea it was the name of a band!

I was quoting Johnny Dangerously.


Count

=SUMPRODUCT((ISNUMBER(SEARCH($A26,$B$1:$E$1)))*(ISNUMBER(SEARCH(B$25,$B$1:$E$1)))*($B$2:$E$18<>""))

Mean

=SUMPRODUCT((ISNUMBER(SEARCH($A26,$B$1:$E$1)))*(ISNUMBER(SEARCH(C$25,$B$1:$E$1)))*($B$2:$E$18))/
SUMPRODUCT((ISNUMBER(SEARCH($A26,$B$1:$E$1)))*(ISNUMBER(SEARCH(C$25,$B$1:$E$1)))*($B$2:$E$18<>""))



Edit: INDEX with a nexted LOOKUP? Mind = Blown