Finding Results between two numbers

  • Thread starter Thread starter mark
  • Start date Start date
M

mark

Scenario: I have 120+ values in a spreadsheet. What I
need to know is how to write a COUNT function that will
count the number of entries betwee two different numbers
(e.g. between 200 and 600). I can get the countif for
less than 200, and one that is greater than 600, but not
between.

TIA
 
I'm sure there is a more elegant way but this works...
=COUNTIF(A1:A12,">2")+COUNTIF(A1:A12,"<6")-COUNT(A1:A12)
The numbers betwee 2 and 6 are counted twice so taking
away the total numbers leaves a count of those between the
two values.
HTH
Graham Yetton
 
Mark,

With what you can get, why not just count all entries and subtract the two
values you have?

Or another way, assuming in A1:A120

=SUMPRODUCT((A1:A120>=200)*(A1:A120<=600))
 
Back
Top