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
|