software

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

Hi!

Try one of these:

=COUNTA(A1:A50)

If there might be formula blanks in any cells the Counta function WILL count
those. This formula WILL NOT count those:

=SUMPRODUCT(--(LEN(A1:A50)gt;0))

Biff

quot;Pawanquot; gt; wrote in message
...
gt; Dear All,
gt;
gt; I have a range of cells, say A1 to A50. I want to write a formula in cell
gt; A51 which will display the number of cells in the range which contain the
gt; data (which are not blank). e.g. if only A1 to A5 cells contain some data
gt; and
gt; other cells are blank, then it should show 5 as the result. The data can
gt; be
gt; either text or numbers.
gt; Is it possible?
gt;
gt; Thank you in advance.
gt;
gt; Regards,
gt; Pawan
Hi Pawan,

Counting non-blank cells can be done by using quot;COUNTAquot; function.

Please note quot;Aquot; after COUNT.

Example: =COUNTA(A1:A50)

Another example for you:

=quot;There are quot;amp; COUNTA(A1:A50) amp; quot; non-empty values and
quot;amp;COUNTBLANK(A1:A50)amp;quot; blank cells from A1 to A50quot;

With kind regards.

NAVEEN.

quot;Pawanquot; wrote:

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