formula to add Alpha?
 

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

formula to add Alpha?
 

Lynn

=COUNTA(A1:A3)

Regards

Trevor


"SLP" wrote in message
...
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

formula to add Alpha?
 

Trevor thank you seems so simple now I feel silly

thank you

"Trevor Shuttleworth" wrote:

Lynn

=COUNTA(A1:A3)

Regards

Trevor


"SLP" wrote in message
...
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

formula to add Alpha?
 

Don't worry ... it's like everything, only easy when you know

Regards

Trevor


"SLP" wrote in message
...
Trevor thank you seems so simple now I feel silly

thank you

"Trevor Shuttleworth" wrote:

Lynn

=COUNTA(A1:A3)

Regards

Trevor


"SLP" wrote in message
...
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