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

Suzy Holmes

=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

Jeff Reisman

@Suzy Holmes

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)

Jeff Reisman

@Suzy Holmes

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)

Suzy Holmes

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