countif(range, between value 1 and value 2)

  • Thread starter Thread starter Gaurav
  • Start date Start date
G

Gaurav

How do I say this?

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

Thanks for reading this :)
 
=Countif(D1:D150,">=86.81%")-Countif(D1:D150,">86.83%")

OR

=Sumproduct((D1:D150>=86.81%)*(D1:D150<=86.83%))
 
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
 
Back
Top