B2{=SUM(IFERROR(--RIGHTB(TEXT({1,-1,0},SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"+",";"),"*",)&";",0,"!0")),2),))
E2{=SUM((0&SUBSTITUTE(MID(A$2:A$12,IFERROR(FIND(D2&"*",A$2:A$12),99)+LEN(D2)+1,2),"+",))*1)
E2{=SUM((0&SUBSTITUTE(MID(A$2:A$12,IFERROR(FIND(D2&"*",A$2:A$12),99)+LEN(D2)+1,2),"+",))*1)
留言
張貼留言