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

[baiaz66]

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

E

 

[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

 

[Guest]

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