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

B

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?
 
E

EdMac

You could try

COUNTIF(Range,<>"")

This will tell you how many cells are not empty

HTH

E
 
D

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?
Click to expand...

=COUNTA(A1:A17
 
V

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