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

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?

You could try

COUNTIF(Range,<>"")

This will tell you how many cells are not empty

HTH

Ed

Originally Posted by [email protected]

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)

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").


"[email protected]" 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?
>
>