Find value grater than X but less than Y

J

John Murf

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
 
B

Bob Phillips

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