Keith Clark wrote:
Is it possible to check a range of cells to see if the values are
between two defined values:
countif(range,">5 and <10")
I cannot seem to get it to work. I get a count of zero even though
there are many values that qualify.
It's not clear if it's possible to do a logical operator there. See if
this suits your purposes:
=COUNT(range)-COUNTIF(range;"<=5")-COUNTIF(range;">=10")
That is, count everything, then take out what you don't want.
Or, use the range in a data pilot and then use the filter options.
--
Bob Long
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
