COUNTIF formula for age range help
Hello,
I am trying to calculate age between 1924. 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
Check out the Formula Handbook template!