COUNTIF formula for age range help


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

  • swilliams
    swilliams ✭✭✭
    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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!