If you want to use a helper column, then you can change each value into a
number and sum that column using this...copied down from U4 to U27
=IF(LEN(U4)0,MID(U4,2,99)*1,"")
The only way I know to sum them without using a helper column would be a
humongus formula, like this......
=SUM(MID(U4,2,99*1),MID(U5,2,99)*1,MID(U6,2,99)*1. ....etc etc to U27)
hth
Vaya con Dios,
Chuck, CABGx3
"excel303" wrote in
message ...
Ok, my spreadsheet is used to track different types of information, I'm
good with the rest of it. The one column I need help with is from
U4:U27. in this column the user will input a letter(F or B) followed by
the quantity of each. Is there a way to sum the numbers only and still
have the original value showing in the cell the user typed in?
1F
1b
Total: 2
--
excel303
------------------------------------------------------------------------
excel303's Profile:
http://www.excelforum.com/member.php...o&userid=31816
View this thread: http://www.excelforum.com/showthread...hreadid=515440