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
|