COUNTIFS Formula Question

Stacy Bourret
Stacy Bourret ✭✭
edited 03/25/21 in Formulas and Functions

Hello,

I am trying to count items that meet specific criteria but can't seem to come up with the right formula. I only want to count the cells in the Division column that contain Human Resources and have a status in the project stage column of "In Progress", "Intake", Prioritized", and "Under Review". This is what I have, but keep getting Unparseable:

=COUNTIFS(Division:Division, "Human Resources", [Project Stage]:[Project Stage] "In Progress", [Project Stage]:[Project Stage], "Intake", [Project Stage]:[Project Stage], "Prioritized", [Project Stage]:[Project Stage], "Under Review")

Thanks in advance!

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You will want to incorporate an OR function with @cell references like so...

    =COUNTIFS(Division:Division, "Human Resources", [Project Stage]:[Project Stage], OR(@cell = "In Progress", @cell = "Intake", @cell = "Prioritized", @cell = "Under Review"))

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!