formula to add Alpha?

G

Guest

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
 
T

Trevor Shuttleworth

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

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alpha characters problem? 1
Formula to sum up customers totals from other sheets 2
Vertical Database to Horizontal? 4
Function to add 3 column (of YES) to give a total % complete 7
Postcode Area extract first alpha letters 6
Sum cells that have both alpha and numbers 3
Lookup array 5
Need help with formula to search and compare data in different col 4

Top