ExcelBanter - Summing part of an Alpha Numeric String

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Summing part of an Alpha Numeric String (https://www.excelbanter.com/excel-worksheet-functions/14715-summing-part-alpha-numeric-string.html)

Arturo

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

Peo Sjoblom

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

Arturo

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

All times are GMT +1. The time now is 06:36 AM.