thanks. it works.


"Dinesh" wrote:

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