Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 23rd 05, 09:57 PM
Arturo
 
Posts: n/a
Default 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   Report Post  
Old February 23rd 05, 10:43 PM
Peo Sjoblom
 
Posts: n/a
Default

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

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert cells containing alpha to numeric ezu Excel Worksheet Functions 14 January 9th 05 11:01 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM
Extracting numeric values from string RJF Excel Worksheet Functions 3 January 5th 05 11:48 PM
Count unique alpha numeric "characters" in a common cell WIM4246 Excel Worksheet Functions 4 December 11th 04 03:27 AM
summing part of cells in a range excelFan Excel Discussion (Misc queries) 2 December 5th 04 01:33 PM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017