Hi everyone, I hope you can shed some light on my calculation!

I want to combine a LOOKUP with a COUNTIFS, but I am not sure which order to nest it, or if maybe there is another formula that would complete my calculation easier.

I want to find a column of data based on the header text (like HLOOKUP does), then count rows if criteria matches in the column next to it and criteria matches in the column itself (like COUNTIFS). I made an example with an explanation in the attached. Hope it makes sense.

Book1.xlsx

Any help would be great. Thanks.