Formula for specific status options not working

SherryBain

The current formula below is just returning a "0" when it should show a count of "3" according to the data

Purpose: Trying to show total number of "In Progress FPI" Status that filters only on "Critical" AND "High" Priority

Formula:

=COUNTIFS(Status:Status, "In Progress FPI", Priority:Priority, "Critical", Priority:Priority, "High")

Data snapshot:

Thanks for any guidance you can provide!

Find more posts tagged with

Accepted answers

All comments

brianw

I think you forgot to bracket your columns your referencing. Does this work?

=COUNTIFS([Status:Status], "In Progress FPI", [Priority:Priority], "Critical", [Priority:Priority[, "High")

Paul H

=COUNTIFS(Status:Status, "In Process FPI", Priority:Priority, OR(@cell = "High", @cell = "Critical"))

brianw

I was able to get this to work using this formula

=COUNTIF(Status:Status, "In Progress FPI") + COUNTIFS(Priority:Priority, "High", Status:Status, "Critical")

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.