Unchecked Cell - Count

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.
Answers
-
=COUNTIF(check:check, @cell = 0)
-
@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.
-
Do you only want to look at certain rows in that column or all rows in the column?
-
@markkrebs - All Rows, no exclusions.
-
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))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!