Inside joke:

I hope you're not gonna go "onlyinsyder" on me!

<VVBG

Biff

"Biff" wrote in message
...
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