Summing a number

[shoot for moon]

I am trying to add number written in below format in cell: Please help me in a single formula so that in next cell I can add below numbers:

0.25/0.568/0.2568/0.12356

[Ace_XL]

Some help here

http://www.mrexcel.com/forum/excel-q...ngle-cell.html

http://www.mrexcel.com/forum/excel-q...ngle-cell.html

http://www.mrexcel.com/forum/excel-q...ated-text.html

[vandan_tanna]

For the string in A1

Please Login or Register  to view this content.

confirmed with <Ctrl>+<Shift>+<Enter> (it is an array formula)
Copy down for rest of the strings

[shoot for moon]

Some help here

http://www.mrexcel.com/forum/excel-q...ngle-cell.html

http://www.mrexcel.com/forum/excel-q...ngle-cell.html

http://www.mrexcel.com/forum/excel-q...ated-text.html

Thanks. I hope one of these link will work.

[vandan_tanna]

Here is non-array version of my solution post #3

Please Login or Register  to view this content.

[shoot for moon]

Hi Vandan,

Thanx for your help. formula is working. Great !
is it possible to explain details how is it working. trying to fig out.

Regards

SM

[shoot for moon]

Hi Vandan,

Thanx for your help. formula is working. Great !
is it possible to explain details how is it working. trying to fig out.

Regards,

SM

[benishiryo]

welcome to the forum, AK. Tony Valko did a formula here & i explained it in post #14:
http://www.excelforum.com/excel-form...ml#post3438268

just change all the "-" to "/". so it's:
=SUM(IF(MID("/"&A1,COLUMN(1:1),1)="/",--(MID(A1,COLUMN(1:1),FIND("/",A1&"/",COLUMN(1:1))-COLUMN(1:1)))))

[Ghozi Alkatiri]

array formula
=SUM(IFERROR(--MID(SUBSTITUTE(A1,"/",REPT(" ",LEN(A1))),(ROW($1:$100)-1)*LEN(A1)+1,LEN(A1)),""))

[XOR LX]

Even more simple, perhaps.

Assuming the cell in question is A1, then, with B1 the active cell, Go to Name Manager and define a new name, Sum_String say, and enter this in the Refers to: box:

=EVALUATE(SUBSTITUTE(Sheet1!$A1,"/","+"))

Exit Name Manager. Then, in B1, enter this formula:

=Sum_String

Copy down as required.

Regards

[shoot for moon]

Thanks for details.