Solved

Count rows that aren't blank in a column

Posted on 2013-01-31
5
255 Views
Last Modified: 2013-01-31
I need to get a count of rows that are not blank in column X.  How do I do this?
0
Comment
Question by:saturation
5 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 38841257
It he column contains only numbers and blanks.

=COUNT(X:X)

If it contains text and/or numbers and blanks

=COUNTA(X:X)
0
 
LVL 4

Expert Comment

by:AllTrip
ID: 38841260
Count Blank Cells -- COUNTBLANK
The COUNTBLANK function will count cells that are empty. Its syntax is:
    =COUNTBLANK(range).
0
 
LVL 4

Expert Comment

by:AllTrip
ID: 38841273
Sorry read your question wrong.  That counts the blank cells, not the not blanks.
0
 
LVL 7

Expert Comment

by:CorinTack
ID: 38841286
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
 

Author Closing Comment

by:saturation
ID: 38841290
Perfect.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Generating a graph via Excel 3 23
Vb.net dynamic formulas in runtime 11 61
Excel Automation VBA 19 25
Help with Excel formula 6 35
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now