<div>
Count Blank Cells -- COUNTBLANK<br />
The COUNTBLANK function will count cells that are empty. Its syntax is:<br />
&nbsp; &nbsp; =COUNTBLANK(range).
</div>


Count Blank Cells -- COUNTBLANK
The COUNTBLANK function will count cells that are empty. Its syntax is:
    =COUNTBLANK(range).

<div>
Sorry read your question wrong. &nbsp;That counts the blank cells, not the not blanks.
</div>


Sorry read your question wrong.  That counts the blank cells, not the not blanks.

<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
I need to get a count of rows that are not blank in column X. &nbsp;How do I do this?
</div>
</div>


I need to get a count of rows that are not blank in column X.  How do I do this?

Count rows that aren't blank in a column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.