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.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 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!