Excel, how do I count cell with data within a range?

[Guest]

I have a row of cells, some with data and some blank. How do I count the
number of blank or non-blank cells and display the total in a cell?

 

[edwardpestian]

COUNTA Function will count the number of non-blank cells in a range.

COUNTA(A2:A8)

Regards,

EP

 

[Chip Pearson]

COUNTBLANK will return the number of blank cells in a
range.E.,g...,
=COUNTBLANK(A1:A10)

COUNTA will count return the number of cells with number or text
in a range E.g.,
=COUNTA(A1:A10)

COUNT will return the number of cells that have numbers only.
E.g.,
=COUNT(A1:A10)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com