Index match & countif

[Kirstym1918]

Hi,

Do you know how I would combine INDEX MATCH with COUNTIF


I need to find a match for D5 in range I4:I86, once that match is found, I need it to then COUNTIF on that exact row vertically for any "H".

Any ideas?

Many Thanks

 

[Eric W]

Did you mean horizontally?

=COUNTIF(INDEX(J4:AA86,MATCH(D5,I4:I86,0),0),"H")

 

[Kirstym1918]

Yes, I meant horizontally haha! I've not had my morning coffee yet This works perfect Eric, thank you. I've been sat for an hour using all variations like this and came up with a grand total of zero

Much Appreciated

 

[Eric W]

Glad to help!