• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

Count rows that aren't blank in a column

I need to get a count of rows that are not blank in column X.  How do I do this?
0
saturation
Asked:
saturation
1 Solution
 
NBVCCommented:
It he column contains only numbers and blanks.

=COUNT(X:X)

If it contains text and/or numbers and blanks

=COUNTA(X:X)
0
 
AllTripCommented:
Count Blank Cells -- COUNTBLANK
The COUNTBLANK function will count cells that are empty. Its syntax is:
    =COUNTBLANK(range).
0
 
AllTripCommented:
Sorry read your question wrong.  That counts the blank cells, not the not blanks.
0
 
CorinTackNetwork EngineerCommented:
NB_VC is correct, what your doing can be accomplished with the CountA function. This counts the number of cells in a given range that have items in them, excluding blank cells.
0
 
saturationAuthor Commented:
Perfect.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now