At 08:43 26/02/2009 +0000, Graham Bowden wrote:
At 21:37 25/02/2009 -0700, Girard Aquino wrote:
Hi! I have a calc question. on one column i have a bunch of even
numbers. I would like to "count" how many are less than or equal to
3, greater than 4 but less than 7, or greater than or equal to 9.
the first and last conditions i got through the COUNTIF (), my
problem is defining the condition for the second one. What function
can i use for this?
[...]
2: Create a column next to original and copy down a formula like:
=IF(AND(B2>4;B2<7);1;0)
Then just sum this column.
This works, of course, but you can simplify the formula somewhat, in fact, to:
=AND(B2>4;B2<7)
These values will display by default as TRUE or FALSE instead of 1
and 0, but will be interpreted as 1 and 0 when you sum them.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
