總和 取正號後數字和 (9433)


C2{=SUM(RIGHT(LARGE(IFERROR(LEFT(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,"-","A"),"/","A"),"+",REPT(" ",99)),ROW($1:$5)*99-98,99)),COLUMN(A:I))*1,)+ROW($1:$5)*10^9,ROW($1:$5)*9-8),9)*1)


留言