countif(range, between value 1 and value 2)
=Countif(D1:D150,"=86.81%")-Countif(D1:D150,"86.83%")
OR
=Sumproduct((D1:D150=86.81%)*(D1:D150<=86.83%))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gaurav" wrote in message
...
How do I say this?
Count the values in D1:D150 that are between 86.81% and 86.83%?
Thanks for reading this :)
|