If there is something in a cell - I want it to summen it!

[baiaz66@gmail.com]

I have a excel sheet where some of the cell is filled with letters.

I want to have a cell that tells me how many cells have something in
it.

How do I do this?

[EdMac]

You could try

COUNTIF(Range,<>"")

This will tell you how many cells are not empty

HTH

Ed

[davesexcel]

I have a excel sheet where some of the cell is filled with letters.

I want to have a cell that tells me how many cells have something in
it.

How do I do this?

=COUNTA(A1:A17)

[Viquar]

If it is just a question of getting the count of non-blank cells, then you
could use the count function.
=Count("A1:J60")
This would give you the count of non-blank cells in the Range("A1:J60").


"baiaz66@gmail.com" wrote:

> I have a excel sheet where some of the cell is filled with letters.
>
> I want to have a cell that tells me how many cells have something in
> it.
>
> How do I do this?
>
>