COUNTIFS Formula Question

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!

Find more posts tagged with

Accepted answers

Paul Newcome

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

All comments

Paul Newcome

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

Stacy Bourret

Worked like a charm!! Thank you so very much!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.