| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a cell w/Alpha numeric characters in mulplication formula | Excel Worksheet Functions | |||
| --alpha = 0.10, alpha = 0.05, and/or | Excel Discussion (Misc queries) | |||
| how do you add up alpha??? | Excel Worksheet Functions | |||
| What is the formula to average alpha? | Excel Worksheet Functions | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
Linear Mode
