I'd like to count the number of people who are between 20 and 30 years old.
COUNTIF (AGE-COLUMN, CONDITION), where CONDITION is something like ">=20 and <=30".
Is there a way to do this?
Thanks!
iMac / iBook / iPhone, Mac OS X (10.5.2)
Hi Mark'
COUNTIF accepts a single condition. For multiple conditions, use COUNTIFS:
COUNTIFS(C,">=20",C,"<=30")
Regards,
Barry
Note: the "C" column reference includes all cells in column C, except cells in Header rows (Row 1 in the example) or Footer rows (none in the example).
B.
Hi Mark'
COUNTIF accepts a single condition. For multiple conditions, use COUNTIFS:
COUNTIFS(C,">=20",C,"<=30")
Regards,
Barry
Note: the "C" column reference includes all cells in column C, except cells in Header rows (Row 1 in the example) or Footer rows (none in the example).
B.
Look into the AND and OR functions
=if(AND(AgeCol>=20,Agecol<=30),true statement, falsestatement)
Jason
Thanks! Didn't think I could have multiple conditions over the same column.
Two conditions in a COUNTIF conditional formula?
