Forum Discussion

Brass Contributor

Aug 08, 2022

Solved

Help with COUNTIF MATCH with specific text

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 colu...

Sample Data 04.xlsx11 KB

excel

Formulas and Functions

Riny_van_Eekelen
Aug 08, 2022
reevesgetsaround In B2:
=COUNTIFS($G$2:$G$14,"Law",$F$2:$F$14,A2)
and copy down.

Riny_van_Eekelen

Platinum Contributor

Aug 08, 2022

reevesgetsaround In B2:

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

and copy down.

reevesgetsaround
Brass Contributor
Aug 08, 2022
It's so obvious when you see the answer! Thank you very much.