Adding columns

[wowster0]

Hi All

I have a column that contains cells that have either numbers and letters, or
nothing at all, what I am trying and failing to do is add this column, not
the contents of the cells but a total number of cells that actually contain
data, for example if there are 40 cells in a column and only 6 have no data
I am trying to get a formula that will show there are 34 cells that DO
contain data.

Hope this is clear enough for a response

Thanks in advance

Steve

 

[JE McGimpsey]

One way:

=COUNTA(A1:A40) & " cells have data"

 

[wowster0]

Brilliant!! that does it many thanks JE McGimpsey