Well, that is because my data starts from A1 and ends at A13. So, I
changed the values accordingly, although the logic is the same.
Roohbir

Ron Rosenfeld wrote:
On 23 Sep 2006 19:28:01 -0700, "roohbir" wrote:

And when I used this =COUNTIF(A1:A13,"="&B1)-COUNTIF(A1:A13,"<="&C1),
it gave 12, where B1 was 41 and C1 was 50. 12 is wrong.
Can you see any reason?
Thanks
Roohbir

Your second function is incorrect. Your equality operator is wrong.

Biff wrote:

=... -COUNTIF(A2:A14,""&D2)
^^^
You used
=... -COUNTIF(A1:A13,"<="&C1)
^^^


--ron