扣為負數 加為正數 計算加總 (14105)

C1{=SUM(IFERROR(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"分","+"),"加","+"),"扣","+-"),"+",REPT(" ",199)),ROW(1:29)*398-199,199)*1,))