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?
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
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" <[email protected]> wrote in message
news:[email protected]...
>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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks