Excel help

[A[L]C]

Hi all,

On the above screenshot, I would like to do a count of how many saturdays and sundays (row 1 value S) have a 'h' in row 3.

ie above it would show 1

Any ideas?



edit: I can do this: =COUNTIF(M3,"H")+COUNTIF(N3,"H")+COUNTIF(T3,"H")+COUNTIF(U3,"H")+COUNTIF(AA3,"H")*COUNTIF(AB3,"H")+COUNTIF(AH3,"H")+COUNTIF(AI3,"H")+COUNTIF(AO3,"H")

but would prefer something that looks for an S and counts the h in the same column

 

[A[L]C]

Do you have to have the answer as a formula or do you just want the answer?

If you put that in a pivot table it'll give you the number straight away. If you just want a number on the sheet then put the pivot table on a second tab and link to the row which comes back with the answer for S.

OOh I dont know anything about pivot tables tbh!

Hope this solution is not too late!

Thanks a lot, I will try that one out, even just to see how it works!

Sorry for the late reply, been extremely busy. I was using Robbie G's solution which seems to work great, will have a look at the others for future reference