How to count unchecked boxes for rows with data only

Sespedido_23

I tried this formula but it's also counting the unchecked rows without data

=COUNTIFS([Client Lost?]:[Client Lost?], 0)

What should be the correct formula?

Nic Larsen

Just add a condition to look at the column/row that should have data to your formula and then run a check to see if its blank.

Update the column name to the one you want to check…

=COUNTIFS([Client Lost?]:[Client Lost?], 0, [Data Column]:[Data Column], NOT(ISBLANK(@cell)

Nic Larsen

Just add a condition to look at the column/row that should have data to your formula and then run a check to see if its blank.

Update the column name to the one you want to check…

=COUNTIFS([Client Lost?]:[Client Lost?], 0, [Data Column]:[Data Column], NOT(ISBLANK(@cell)

Sespedido_23

perfect! thank you @Nic Larsen