COUNTIFS when looking for two criteria but one of the criteria is in a range

[johnmitch38]

On the attached example, I want to count the value "h" in each row (I12:NI12) for each drivername (column D)

However, I only want to count the bank holidays which are highlighted yellow. My list of bank holidays is in A12:A28.

I could just use a COUNTIFS if both criteria were fixed but I'm not sure how to adapt the formula where I'm looking for one value from a range in another range of cells?

[JohnTopley]

Try

=SUM(COUNTIFS($I12:$NI12,"h",$I$11:$NI$11,$A$12:$A$27))

Enter with Ctrl+Shift+Enter (array formula)

[johnmitch38]

Fantastic - much appreciated thanks.