Help with COUNTIF MATCH with specific text

[reevesgetsaround]

Hello all

I'm going round in circles with a formula which should be very simple. I know I have done something similar before but am drawing a blank, currently.

On this sample document in column B, I would like to count the number of applications for the corresponding universities in column A, but narrowed down by a specific subject, "Law" for example in this document.

I'd be very grateful for any help.

Best Regards

[#2 · Accepted solution]

@reevesgetsaround In B2:

=COUNTIFS($G$2:$G$14,"Law",$F$2:$F$14,A2)

and copy down. 

[#3]

It's so obvious when you see the answer! Thank you very much.