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
Check out the Formula Handbook template!