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
"BRKirk" wrote in message
...
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?