add numbers in same cell with Auto Sum

[Will123]

I am using XP 2003 Excel and have a spreadsheet with a large column of cells
that have multiple numbers in each cell and the numbers are separated by a
slash or divide line, ie: '170/13/3. These #'s are actually 170+13+3. Is
there a way to do an Auto Sum on this column without changing the slash lines
to a plus sign?
thanks, Will

 

[Roger Govier]

Hi Will

You will need to use an extra column and a bit of Excel trickery!!.
On the basis that your column of numbers is in column A, first create a
named formula
Insert>name>Define>
Name addup
Refers to =EVALUATE("="&SUBSITUTE($A1,"/","+"))

In B1 enter
=addup
Copy down as far as required
Sum column B.