Hi,

Use text to columns to split the cell values then you can use the @sum
formula.

Hope this helps.

"Francois Taljaard" wrote:

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.