加總 多位置數字 (10973)


D2{=SUM(IFERROR(RIGHT(SMALL(IFERROR(ROW($1:$11)/1%+MID(SUBSTITUTE(A2,",",REPT(" ",99)),ROW($1:$11)*99-98,99),""),MID(SUBSTITUTE(C2,",",REPT(" ",9)),ROW($1:$5)*9-8,9)),2)*1,))


留言