Count non blank cells in col A

P

Peo Sjoblom

=COUNTA(A1:A10000)

or if you have formulas returning blanks

=SUMPRODUCT(--(A1:A10000<>""))
 
M

Mark Graesser

Mario,
Excel has a function for this:

=COUNTA(A:A)

Good Luck,
Mark Graesser
(e-mail address removed)


----- Mario wrote: -----

Can any help with the function to count non blank cells
in a column.

Thanks
Mario
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Index Match to ignore blank cells 0
How to display zero value in blank fields of Cross Tab query 0
use month in cell date to sum all relevant cells 2
Count Blank Cells with Conditions 3
Publisher adding blank page when printing my booklet... 2
Counting blank cells between non-blank cells 4
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1

Top