Countifs multiple Status and one priority level

Good afternoon,

I am in need of assistance with adding multiple Status(column) from a drop down and sorting them by priority. I was able to get two formulas working as a start but cannot seem to add multiple drops downs from the status. I was able to develop a report so show this information but I am seeking a formula for the sheet summary.

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

I am looking to see all the "High" Priority (Column) items from the three different Status's (Column) "In Progress", "Blocked", and "Ongoing".

Any help would be wonderful!

Find more posts tagged with

Accepted answers

All comments

Nic Larsen

Try:

=COUNTIFS(Status:Status, OR(@cell = "In Progress", @cell = "In Progress", @cell = "Blocked", @cell = "Ongoing"), Priority:Priority, "High")

A.Valadez

Nic,

Thank you! You are a life saver! I hate to be a bother but would you be able to help me with another issue?

I am trying to compute the items added to the list within the past seven days by status and project type. I was only able to figure out the seven days and the status, not the project type.

=COUNTIFS(Status:Status, OR(@cell = "In Progress", @cell =

"Ongoing"), [Start Date]:[Start Date], AND(@cell >= TODAY(-7), @cell <= TODAY()))

---Info attempting to measure---

Status (drop down column)-"In Progress", "Ongoing"

Type (drop down column)- "Project", "Initiative"

Start Date (date column)-Seven Days

Nic Larsen

Glad it worked. So if I'm understanding, you're just adding one additional criteria for Type as the rest is working? Assuming the column is called Type, you would follow the same structure as the rest of the formula:

=COUNTIFS(Type:Type, OR(@cell = "Project", @cell = "Initiative"), Status:Status, OR(@cell = "In Progress", @cell = "Ongoing"), [Start Date]:[Start Date], AND(@cell >= TODAY(-7), @cell <= TODAY()

A.Valadez

Nic! Thank you so much! Seeing it written allowed me to create a few formulas based off what you sent. Thank you!

Nic Larsen

Glad 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.