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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Yes or No Value if Dollar amount between two numbers 1
In a set of dates, can you count the number of Jan '07 instances? 4
Help with function / Formula 3
Excel - count if a number falls within an array in a column & add 3
sumif multiple criteria, some same cell 6
COUNTIF....how to use >=0 but <9 as CRITERIA 3
summary 1

Back
Top