Unable to Count Blank/Empty Cells in a Column

I'm trying to count open/active events that have not been Resolved.

Each event is on a separate row with a column called Resolved.

Resolved Cells will either be empty/blank or contain a date & time as alphanumeric free text. Example below shows date on top of time in cell (I forced with ALT Enter after date)

3DEC

0859 ET

The sheet currently has 16 rows… only 2 have no content in Resolved Cell the others are as per above example.

When I use either of these formulas, I get a count of 36, not 2

=COUNTIF(Resolved:Resolved, "")

=COUNTIF([Resolved]:[Resolved], ISBLANK(@cell ))

Is there another way to count empty cells in a column?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

It is most likely also counting empty rows at the bottom of your sheet. I would suggest switching to a COUNTIFS so you can add another range/criteria set for another column that will not be blank.

=COUNTIFS(Event:Event, @cell <> "", Resolved:Resolved, @cell = "")

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.