SOLVED

Help with COUNTIF MATCH with specific text

Brass Contributor

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 Replies
best response confirmed by reevesgetsaround (Brass Contributor)
Solution

@reevesgetsaround In B2:

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

and copy down. 

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

Accepted Solutions
best response confirmed by reevesgetsaround (Brass Contributor)
Solution

@reevesgetsaround In B2:

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

and copy down. 

View solution in original post