countif functions
Try : =COUNTIF(Range,"10") - COUNTIF(Range,"20") As I understand your
question, you want a count of the number of cells that have a a value
*between* (!) 10 and 20 ( that are equal to 11 as a minimum and equal to 19,
as a maximum).I think this will do the job for you.
"bsantona" wrote in message
...
I'm trying to get a count of cells that have a range of data for instance
I
want a count of cells that have data between 10 - 20.
Any ideas would be appreciated.
|