Hi

Need to split cell values and sum.
Cell A1: 0,20,300,20,300
Cell A2: 280,34,200,129,0

Result for A1 = 640
Result for A2 = 643

Note that the length of cell and values are not consistent.

Any help much appreciate.