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!
Answers
-
Try:
=COUNTIFS(Status:Status, OR(@cell = "In Progress", @cell = "In Progress", @cell = "Blocked", @cell = "Ongoing"), Priority:Priority, "High")
-
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
-
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()
-
Nic! Thank you so much! Seeing it written allowed me to create a few formulas based off what you sent. Thank you!
-
Glad to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!