Adding numbers in between slashes

[asad]

Hi Guys,

Is there a formula that can add numbers separated by slashes in a cell? So for example I have 0/2/1/0/3, the desired result is 6.

Thanks
Asad

 

[asad]

Use a Named range
Select cell B1
With Name Manager
New I used the name "Calc".
Refers to: =EVALUATE(SUBSTITUTE(!A1,"/","+"))

This obviously is equivalent to the UDF Eval.

Works perfect Dave. Thanks a lot.
Asad

 

[István Hirsch]

... Or try this (confirm with Ctrl - Shift - Enter):

=SUM(IFERROR((--TRIM(MID(SUBSTITUTE("/"&A1,"/",REPT(" ",50)),50*ROW($1:$50),15))),0))

 

[asad]

Another very good formula. Thanks a lot.

 

[István Hirsch]

You are welcome.