Count amount text appears with extra criteria

I have a table with a variety of columns in, which is for time and attendance. There is a column called name and then 10 columns with a variety of characters in. I want to count by name how many times the letter H appears. Their name will appear more than once in the rows section though.

please can you upload your spreadsheet?

if your names are in col a1:a12 for eg put this in col b1

=SUMPRODUCT(LEN(A1:A12)-LEN(SUBSTITUTE(A1:A12,"H","")))

Perhaps:

Please Login or Register  to view this content.

references to name & H can be replaced with cell references containing terms of interest

If you're using SUMPRODUCT en masse (in matrix for ex.) you should pursue alternative approaches.

doh silly me i re-read post and realised that I got the wrong end of the stick - nothing new there!!