C2{=SUM((0&LEFT(TRIM(MID(SUBSTITUTE(B2,"＋",REPT(" ",99)),ROW($1:$9)*99-98,99)),FIND("×",TRIM(MID(SUBSTITUTE(B2,"＋",REPT(" ",99)),ROW($1:$9)*99-98,99))&"×")-1))*IFERROR(MID(TRIM(MID(SUBSTITUTE(B2,"＋",REPT(" ",99)),ROW($1:$9)*99-98,99)),FIND("×",TRIM(MID(SUBSTITUTE(B2,"＋",REPT(" ",99)),ROW($1:$9)*99-98,99))&"×")+1,9)*1,1))
留言
張貼留言