COUNTIF formula for age range help

ealexis

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")

swilliams

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!

Nic Larsen

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))

swilliams

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!