Why does this return the value of 0 when each range/criteria pair return 6 and 12 respectively?
=COUNTIFS([N/A]3:[N/A]20, 1, Done3:Done20, 1) This one returns 0. It should be 18
=COUNTIFS([N/A]3:[N/A]20, 1) This returns 6
=COUNTIFS(Done3:Done20, 1) This returns 12
Best Answer
-
Your combined formula is asking it to count all the rows where BOTH N/A and Done are checked/true/=1.
To get it to count rows where N/A is checked/true/=1, and to count rows where Done is checked/true/=1, you'll just want to add the two individual COUNTIFS together:
=COUNTIFS([N/A]3:[N/A]20, 1) + COUNTIFS(Done3:Done20, 1)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
Your combined formula is asking it to count all the rows where BOTH N/A and Done are checked/true/=1.
To get it to count rows where N/A is checked/true/=1, and to count rows where Done is checked/true/=1, you'll just want to add the two individual COUNTIFS together:
=COUNTIFS([N/A]3:[N/A]20, 1) + COUNTIFS(Done3:Done20, 1)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you so much, Jeff! That did the trick.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!