how to calculate the number of non blank cells from any column?

M

Mahesh

I would like to calculate the number of non blank cells in one columns.
How do i do it.
I am not able to use ISBLANK formula as I don't know how to use it.
Please explain.
 
P

Pete_UK

Use the COUNTA( ) function - Excel help gives details of its use.

Hope this helps.

Pete
 
M

Max

Mahesh said:
I would like to calculate the number of non blank cells in one columns.
Click to expand...

An option to try if you have formula cells in the col which may return
"blanks", ie:"", and these formula returns are to be treated the same way as
real empty cells in the col is to use something like in say, C1:
=SUMPRODUCT(--(B1:B20<>""))
Adapt the range to suit. Note that SUMPRODUCT can't accept entire col refs.
 
Top