How to count cells with a value in a column

Elisa Hogan

Hello,

Trying to figure out how to count cells with values in one column. For example:

I want to know how many cells contain a value on the following:

Column 2

Josh

Robert

Alexandra

Greg

My ideal answer would be that there are 4 values in column 2.

Any idea what the formula is for this?

I have the formula for blank cells:

=COUNTIF([Column2]2:[Column2]11, " ")

Thanks!

Elisa

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

"Not Equal To" is <>. So you would use that to say "not equal to blank".

=COUNTIFS([Column2]2:[Column2]11, <> "")

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.