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
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
Bob Long wrote:
Simpler:
=COUNTIF(range;5)-COUNTIF(range;=10)
And another one:
=SUMPRODUCT(range5;range=10)
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail:
On Fri, 2010-02-19 at 12:32 +0100, Andreas Saeger wrote:
Bob Long wrote:
Simpler:
=COUNTIF(range;5)-COUNTIF(range;=10)
And another one:
=SUMPRODUCT(range5;range=10)
sumproduct worked perfect, thanks!
Keith