Dear All,

I have a range of cells, say A1 to A50. I want to write a formula in cell
A51 which will display the number of cells in the range which contain the
data (which are not blank). e.g. if only A1 to A5 cells contain some data and
other cells are blank, then it should show 5 as the result. The data can be
either text or numbers.
Is it possible?

Thank you in advance.

Regards,
Pawan