SUM of values in a comma delimited cell

Originally Posted by Excelfriend

Dan,

=SUM(MID(A1,1,1)+MID(A1,3,1)+MID(A1,5,1)+MID(A1,7,1))

While that will do the job, and is acurate based on the limited data provided, it also makes some dangerous assumptions.

Originally Posted by Danexcel

Hello,

Is there a SUM formula I can place in cell B1 that will sum values I have in A1 expressed as 1,4,6,7. The number I should see in B1 is 18.

Any help with this is appreciated.

Dan

Dan, you need to give a better picture of your situation. Two questions immediately pop to mind: Is your data always single digit numbers? Is it always groups of four?