Calculating data between two given parameters
 

If i have a range of A1:A300 and the range of numbers within those cells
could be anything from 1 to 50 how do i count cells that contain numbers
greater than 20 but less than 31?

Thanks

Calculating data between two given parameters
 

=COUNTIF(A1:A300,"20")-COUNTIF(A1:A300,"30")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Craig" wrote in message
...
If i have a range of A1:A300 and the range of numbers within those cells
could be anything from 1 to 50 how do i count cells that contain numbers
greater than 20 but less than 31?

Thanks

Calculating data between two given parameters
 

Unless the numbers are contrained to being integers, it may be preferable to
use =COUNTIF(A1:A300,"20")-COUNTIF(A1:A300,"=31")
--
David Biddulph

"Bob Phillips" wrote in message
...
=COUNTIF(A1:A300,"20")-COUNTIF(A1:A300,"30")

"Craig" wrote in message
...
If i have a range of A1:A300 and the range of numbers within those cells
could be anything from 1 to 50 how do i count cells that contain numbers
greater than 20 but less than 31?

Thanks