You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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?
