Hello All I look to see if I could find something on this but didn't get
quite what I needed. I have a user who wants to add some columns up but
there are only alpha characters in the columns
for example
A1: Los Angeles
A2: Miami
A3: Seattle
Total: 3
now in A4 all she wants to do is add up the number of columns above. So the
total should be 3.
I know how to do it with numbers but not with alpha characters
Thanks
Lynn
Trevor Shuttleworth - 11 Jun 2007 18:32 GMT
Lynn
=COUNTA(A1:A3)
Regards
Trevor
> Hello All I look to see if I could find something on this but didn't get
> quite what I needed. I have a user who wants to add some columns up but
[quoted text clipped - 15 lines]
> Thanks
> Lynn
SLP - 11 Jun 2007 18:45 GMT
Trevor thank you seems so simple now I feel silly
thank you
> Lynn
>
[quoted text clipped - 23 lines]
> > Thanks
> > Lynn
Trevor Shuttleworth - 11 Jun 2007 22:12 GMT
Don't worry ... it's like everything, only easy when you know
Regards
Trevor
> Trevor thank you seems so simple now I feel silly
>
[quoted text clipped - 30 lines]
>> > Thanks
>> > Lynn