How do I count non-blanks in a column?

Hi - I have a column in a referenced sheet that I need to count cells that have data in them. I'm struggling with the countif formula, not sure what to put for not counting the blanks and only counting the cells with data.

Right now I have =countif({Lisa - test smartsheet Range 1}), …..and then I get stumped. The data is numerical with a dash so it can't just be excluding numbers or text. Thank you - sorry if this doesn't make sense.

Find more posts tagged with

Accepted answers

MarceHolzhauzen

Hey @Murz

There are two formulas that you can use

=count({Lisa - test smartsheet Range 1})

The formula returns the number of cells in that range that contain numeric values. If the range has cells with non-numeric data (like text), they will not be included in the count.

If you want to count all non-blank cells, regardless of whether they contain numbers or text, you would use the COUNTA function instead of COUNT.

The countif formula is good for instances where you have a different or specific set of criteria

All comments

MarceHolzhauzen

Hey @Murz

There are two formulas that you can use

=count({Lisa - test smartsheet Range 1})

The formula returns the number of cells in that range that contain numeric values. If the range has cells with non-numeric data (like text), they will not be included in the count.

If you want to count all non-blank cells, regardless of whether they contain numbers or text, you would use the COUNTA function instead of COUNT.

The countif formula is good for instances where you have a different or specific set of criteria

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.