Remember Me?

#1
February 23rd 05, 09:57 PM
 Arturo Posts: n/a
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
February 23rd 05, 10:43 PM
 Peo Sjoblom Posts: n/a

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
February 23rd 05, 10:59 PM
 Arturo Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post ezu Excel Worksheet Functions 14 January 9th 05 11:01 PM Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM RJF Excel Worksheet Functions 3 January 5th 05 11:48 PM WIM4246 Excel Worksheet Functions 4 December 11th 04 03:27 AM excelFan Excel Discussion (Misc queries) 2 December 5th 04 01:33 PM

All times are GMT +1. The time now is 01:50 PM.