Hi,

When I enter the formula which is at the end, I get the result of 3 in Col
B, row 2 instead of 2.


Category New Term
A 2
B
C
D
E
F



New A
New A
New B
Term B
Term E
New F
Term D
Term C
Term C
New F
New B
Term A

{=IF($C$13:$C$24="new",COUNTIF($D$13:$D$24,"A"))}

Thank you for taking time to solve the formula.

Dinesh