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.