COUNTIF non blank cells

I created a dashboard metrics sheet that is referencing data from various sheets using columns and I am stuck! I would like to have a metric for a column in a sheet that will count all of the sites that have a number assigned to them, some cells are blank and I only want the ones with a number.

How can I count all those cells that are not blank? This is what I have and I know I'm totally off....

Reference sheet --> {Master Data Sheet Site Number}

Column Name --> Site Number

=COUNTIF({Master Data Sheet Site Number}, NOT(ISBLANK@[Site Number]))

Find more posts tagged with

Accepted answers

ker9

If you need to specify count numbers then:

=COUNTIF([Column Name]:[Column Name], ISNUMBER(@cell))

All comments

ker9

Hi @laura.sandoval

If you do not need to specify anything other than not blank, use Count. It only counts non blank cells.

=Count(RANGE)

Hope this helps!

ker9

If you need to specify count numbers then:

=COUNTIF([Column Name]:[Column Name], ISNUMBER(@cell))

laura.sandoval

Ahhh it worked thank you so much!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.