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.

Find more posts tagged with

Accepted answers

All comments

markkrebs

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

Gaurav Chauhan

@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

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

Gaurav Chauhan

@markkrebs - All Rows, no exclusions.

markkrebs

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))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.