Multiple Countifs Using Symbols
I am not an advanced formula user. I want to find the count of records that have multiple criteria. The formula I'm using now returns a value of 3, but should be 9.
=COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), {AI Priority}, <>"Low")
I have a symbol column in my Action Item page that uses the 3 priorities (High, Medium, Low). Of the 9 records, three priorities are "Medium" and the remaining 6 are blank "". I want the formula to return null (""), "Medium", and "High" counts summed together (9). Basically, I want to exclude records with "Low" priority, but using my formula it returns a value of 3, seemingly disregarding blank priority values.
Thanks in advance for any assistance you can provide in cleaning up my formula.
Answers
-
=COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), OR(@cell <> "Low", @cell = ""
-
L_123, thank you for your response. I receive a "#INVALID OPERATION" error when using this formula. Do I need to use the {AI Priority} reference instead of @cell? I tried to replace @cell with {AI Priority}, but doesn't seem to work.
-
Yeah sorry, I cut out the reference....
=COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), {AI Priority}, OR(@cell <> "Low", @cell = ""
-
L_123, This works great. Thank you kindly!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- New program proposals are submitted via a form and collected on Sheet 1. When approved by a team leader, the row is copied to Sheet 2. I want to capture the date the copied occurred, which I thought w…
- I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?
- Hi, I'm looking to write a formula using references to a rate sheet (screenshot attached with sensitive information redacted). We have several types of rates here, and also ones that are per word, whi…