COUNTIF formula for age range help
Hello,
I am trying to calculate age between 19-24. Below is the most recent formula I have tried but I keep getting Incorrect Argument Set. Can someone help?
=COUNTIF({Adult Education CURRENT Roster Range 7}, "<19", {Adult Education CURRENT Roster Range 7}, ">24")
Best Answer
-
It looks like you're needing to use the COUNTIFS function instead of COUNTIF. Since COUNTIF only expects one range and one criterion, you're getting the error you see there. You'd also want to remove the quotation marks around the test criteria.
Hope this helps!
Answers
-
Try it like this, assuming you have ages and not DOB's in your range:
=COUNTIF({Adult Education CURRENT Roster Range 7}, AND(@cell >= 19, @cell <= 24))
-
It looks like you're needing to use the COUNTIFS function instead of COUNTIF. Since COUNTIF only expects one range and one criterion, you're getting the error you see there. You'd also want to remove the quotation marks around the test criteria.
Hope this helps!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!