countifs with multiple criteria NOT equal to
I'm trying to create a formula to count a dataset if not equal to multiple criteria:
=COUNTIFS({TTKENG 2021 RoadMap Priority}, "Red", {TTKENG 2021 RoadMap Range 3}, <>"9 Released", {TTKENG 2021 RoadMap Range 3}, <>"X On Hold", {TTKENG 2021 RoadMap Range 3}, <>"Z Rejected")
I want to count all EXCEPT those items "9 Released", "X On Hold" and "Z Rejected". This is giving me a number, but it isn't calculating correctly. Any suggestions?
Best Answer
-
Could it possibly be including blank rows in the count? If so, add in another range/criteria set where the criteria is
<> ""
Answers
-
Could it possibly be including blank rows in the count? If so, add in another range/criteria set where the criteria is
<> ""
-
It wasn't counting blanks and I wanted them too so I modified your suggestion to use "" but without the <> and it worked! Thank you!
-
Happy to help. 👍️
-
@Paul Newcome, could u pls suggest what is wrong with my formula. I want to count the number of other values available in a column other than "Kentico 13"
=COUNTIFS({Testing Log Raw Range 1}, "2023", {Testing Log Raw Range 2}, "IAT", {Testing Log Raw Range 7}, <>"Kentico 13")
-
@Sarita Sah Are you able to provide a screenshot of the source data? There are no immediate issues with your formula, so we are going to have to dig in a little bit more.
-
@Paul Newcome Sure, I have this data in a Smartsheet for last 3 years for IAT and UAT, I am counting only for IAT and only for 2023 for "Kentico 13" which is available in the Kentico column.
-
What happens if you remove the quotes from around 2023 in the COUNTIFS?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!