Bob Long wrote:
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")
Simpler:
=COUNTIF(range;">5")-COUNTIF(range;">=10")
--
Bob Long
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org