Unchecked Cell - Count

Gaurav Chauhan · 01/23/25

Hi Team

I have used three different logic and none are able to give me a count of the Unchecked cells. They are giving me a count of all Cells which is incorrect. How do I fix the issue -

=COUNTIF({Column Name}, "")

=COUNTIF({Column Name}, false)

=COUNTIF({Column Name}, 0)

Thanks.

markkrebs · 01/23/25

=COUNTIF(check:check, @cell = 0)

Gaurav Chauhan · 01/23/25

@markkrebs Thank you. I updated the formulae based on your suggestion, but it still gives me the count of all rows/cells.. I am unsure what could be wrong here.

markkrebs · 01/23/25

Do you only want to look at certain rows in that column or all rows in the column?

Gaurav Chauhan · 01/23/25

@markkrebs - All Rows, no exclusions.

markkrebs · 01/23/25

you may be running into the blank row issue. in my screenshot the answer should be 4 but SS adds extra rows to a sheet. In this case we need another parameter pointing to a column that shouln't have blanks in it like the primary column so then the formula would be =if(isblank(primary@row),"",COUNTIF(check:check, @cell = 0))