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!