countif(range, between value 1 and value 2)
 

How do I say this?

Count the values in D1:D150 that are between 86.81% and 86.83%?

Thanks for reading this :)

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

countif(range, between value 1 and value 2)
 

Try one of these:

This one *includes* both boundaries:

=COUNTIF(D1:D150,"=86.81%")-COUNTIF(D1:D150,"86.83%")

This one *excludes* the boundaries:

=COUNTIF(D1:D150,"86.81%")-COUNTIF(D1:D150,"=86.83%")

If the numbers are all terminated at 2 decimal places then this might do
just as well:

=COUNTIF(D1:D150,86.82%)

Format as GENERAL or NUMBER

--
Biff
Microsoft Excel MVP


"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 :)