# Why does this return the value of 0 when each range/criteria pair return 6 and 12 respectively?

Options

=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

• ✭✭✭✭✭✭
Options

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

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭
Options

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

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• Options

Thank you so much, Jeff! That did the trick.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!