I'm trying to count the empty checkboxes in a column if the neighboring column is not empty

Michael Beale

I am newly certified and am looking for help with formulas.

I want to count the unchecked boxes if there is something in the Action # column and do nothing if it is empty. What am I missing?

=IF(NOT(ISBLANK([Action #]),(COUNTIF(Completed:Completed, =0))))

Many thanks,

Michael

David Joyeuse

Hi @Michael Beale

Have you tried this:

=COUNTIFS([Action #]:[Action#], ISBLANK(@cell), [Completed]:[Completed], 0)

Hope it helped!

Michael Beale

Hi David,

Thank you for your formula. Unfortunately, I got an unparseable error.

Michael Beale

I got this to work if I delete the extra rows. =COUNTIF(Completed:Completed, =0)

However, if someone adds blank rows, that could throw off the count.