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

One way:

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

In article <(E-Mail Removed)>,
"wowster0" <(E-Mail Removed)> wrote:

> 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

Brilliant!! that does it many thanks JE McGimpsey

"JE McGimpsey" <(E-Mail Removed)> wrote in message
news:jemcgimpsey-(E-Mail Removed)...
> One way:
>
> =COUNTA(A1:A40) & " cells have data"
>
> In article <(E-Mail Removed)>,
> "wowster0" <(E-Mail Removed)> wrote:
>
>> 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