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)

@reevesgetsaround In B2:


and copy down. 

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