| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Summing part of an Alpha Numeric String
A1 = 1 X
A2 = 2 X A3 = 3 X A4 = 6 Is there some sum left formula that will allow me to total the numbers in cells A1:A3 and omit the text to the right? Thank you, Arturo |
|
#2
|
|||
|
|||
|
In your example the numbers are single digits, if that's the case
=SUMPRODUCT(--(LEFT(A1:A3,1))) -- Regards, Peo Sjoblom "Arturo" wrote in message ... A1 = 1 X A2 = 2 X A3 = 3 X A4 = 6 Is there some sum left formula that will allow me to total the numbers in cells A1:A3 and omit the text to the right? Thank you, Arturo |
|
#3
|
|||
|
|||
|
THANKS!
"Peo Sjoblom" wrote: In your example the numbers are single digits, if that's the case =SUMPRODUCT(--(LEFT(A1:A3,1))) -- Regards, Peo Sjoblom "Arturo" wrote in message ... A1 = 1 X A2 = 2 X A3 = 3 X A4 = 6 Is there some sum left formula that will allow me to total the numbers in cells A1:A3 and omit the text to the right? Thank you, Arturo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert cells containing alpha to numeric | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Extracting numeric values from string | Excel Worksheet Functions | |||
| Count unique alpha numeric "characters" in a common cell | Excel Worksheet Functions | |||
| summing part of cells in a range | Excel Discussion (Misc queries) | |||
Hybrid Mode
