software

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,quot;lt;=30quot;)- countif(B2:B32,quot;lt;=19quot;)
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:B32gt;20),--(B2:B32lt;=30))

or

=SUMPRODUCT(--(B2:B32gt;=H20),--(B2:b32lt;=H21))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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