數字計算 有乘有加有单位 (10638)

E4{=PRODUCT(RIGHT(LARGE(IFERROR(MID(SUBSTITUTE(LEFT(C4,FIND("+",C4)-1)&"*1","*",REPT(" ",9)),{1,10},ROW($1:$9))*1,)+{1,2}*10^9,{1,10}),9)*1)+PRODUCT(RIGHT(LARGE(IFERROR(MID(SUBSTITUTE(MID(C4,FIND("+",C4)+1,9)&"*1","*",REPT(" ",9)),{1,10},ROW($1:$9))*1,)+{1,2}*10^9,{1,10}),9)*1)