加總 三個數字 (10145)

C2=SUM(TEXT({1,-1,0},"[$"&SUBSTITUTE(B2,"+","];[$")&"]")*1)

最多 9數字 D2=SUMPRODUCT((0&TRIM(MID(SUBSTITUTE(B2,"+",REPT(" ",99)),ROW($1:$9)*99-98,99)))*1)