COUNTIFS not working correctly with dropdown critierion
Joe D
✭✭
I am using the following formula to count the number of rows that have both [Pricing] unchecked and [Status] showing any other value EXCEPT "Not Applicable.
=COUNTIFS(Pricing:Pricing, 0, Status:Status, <>"Not Applicable")
When I use the above formula, it keeps showing the incorrect value.
I've filtered the sheet using the same criteria (Pricing is unchecked and Status is not one of "Not Applicable") and it manages to show the correct value.
Answers
-
Try this:
=COUNTIFS(Pricing:Pricing, @cell <> 1, Status:Status, <>"Not Applicable")
-
I pasted in that formula and it still didn't work. Does it matter of some of the Status fields are blank?
-
Would you want the blanks included or excluded from the count?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!