逗點前數字總和 (9832)

C1{=SUM(RIGHT(SMALL(IFERROR(RIGHT(TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"万","0000"),"，",REPT(" ",99)),ROW(1:9)*99-98,99)),COLUMN(A:I))*1,)+ROW(1:9)*10^8,ROW(1:9)*9),8)*1)