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

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.

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

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

Hope this helps.

Pete

Mahesh wrote:
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.

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

"Mahesh" wrote:
I would like to calculate the number of non blank cells in one columns.

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---