[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • 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
 
CorinTackCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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