Find value grater than X but less than Y

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What formulea do I use to find a the number of cells with a value greater
than 20 but less than 30 in a range of cells B2:B32 in Excel 2002
Countif(B2:B32,"<=30")- countif(B2:B32,"<=19")
Is there an easier way to write this?
Can the lower and upper limits be set in refrence cells? say H20 and H21
 
Not much easier, but

=SUMPRODUCT(--(B2:B32>20),--(B2:B32<=30))

or

=SUMPRODUCT(--(B2:B32>=H20),--(B2:b32<=H21))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

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

SMALL function to find X smallest number greater than Y 6
FORMULA FOR if(GREATER THAN, BUT LESS THAN,THIS,OR THAT 2
Help with Nested Range counts 3
Lookup values if Value 1 is x or y and Value 2 is a,b,c,d. 3
Help with an "If Statement" 7
How to find columns which contain less than x null values 1
Lookup based on range of dates 1
INDEX formula returns #REF! error for ranges larger than two cells 3

Back
Top