Find value grater than X but less than Y
 

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

Find value grater than X but less than Y
 

Not much easier, but

=SUMPRODUCT(--(B2:B3220),--(B2:B32<=30))

or

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"John Murf" <John wrote in message
...
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