countif(range, between value 1 and value 2)

[Gaurav]

How do I say this?

Count the values in D1150 that are between 86.81% and 86.83%?

Thanks for reading this

 

[RagDyer]

=Countif(D1150,">=86.81%")-Countif(D1150,">86.83%")

OR

=Sumproduct((D1150>=86.81%)*(D1150<=86.83%))

 

[T. Valko]

Try one of these:

This one *includes* both boundaries:

=COUNTIF(D1150,">=86.81%")-COUNTIF(D1150,">86.83%")

This one *excludes* the boundaries:

=COUNTIF(D1150,">86.81%")-COUNTIF(D1150,">=86.83%")

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

=COUNTIF(D1150,86.82%)

Format as GENERAL or NUMBER