It may seem to be counterintutitve to use "" in the second Countif formula
but if you tried it you would see that it produces the correct result.

If you prefer, you can use this formula:

=SUMPRODUCT(--(A1:A13=B1),--(A1:A13<=C1))

The Countif formula is faster.

Biff

"roohbir" wrote in message
ups.com...
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