software

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?


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

COUNTA(A2:A8)

Regards,

EP--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=541388COUNTBLANK 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
quot;BRKirkquot; gt; wrote in message
news
gt;I have a row of cells, some with data and some blank. How do I
gt;count the
gt; number of blank or non-blank cells and display the total in a
gt; cell?