Adding columns

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 <4cp9mjF16tsbgU1@individual.net>,
"wowster0" <wowster0@nospam.lycos.com> 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" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-AAA274.12063714052006@msnews.microsoft.com...
> One way:
>
> =COUNTA(A1:A40) & " cells have data"
>
> In article <4cp9mjF16tsbgU1@individual.net>,
> "wowster0" <wowster0@nospam.lycos.com> 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