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

[Guest]

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.

 

[Pete_UK]

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

Hope this helps.

Pete

 

[Guest]

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.

---