There are two methods I can think of...
1: Use DCOUNT - it is slightly more awkward but will get you there. You will
need to label your columns and then copy these labels somewhere and put the
conditions below. This allows for quite complex sets of conditions.
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.
Hope this helps
Grey B
----- Original Message -----
From: "Girard Aquino" <girardaqu...@hotmail.com>
To: "Openoffice.org" <users@openoffice.org>
Sent: Thursday, February 26, 2009 4:37 AM
Subject: [users] how to countif 4>x>7
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?
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
