總和 相乘後 (10224)

I5:L11=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A5,"&","%"),"%",REPT(" ",99)),COLUMN(A1)*198-99,99))

N5:Q11{=SUM(IFERROR(MID(SUBSTITUTE(SUBSTITUTE($A$5:$A$11,"&",REPT(" ",99)),I5,),{1,2,3,4}*99-98,99)*$B$5:$B$11,))

E3:E11{=IFERROR(INDIRECT(TEXT(RIGHT(LARGE((COUNTIF(E$2:E2,I$5:L$11)=0)*N$5:Q$11*10^10+ROW($5:$11)/1%+COLUMN(I:L),1),4),"!R0C00"),),"")

G3:G11{=IF(E3="","",SUM(IFERROR(MID(SUBSTITUTE(SUBSTITUTE(A$5:A$11,"&",REPT(" ",99)),E3,),{1,2,3,4}*99-98,99)*B$5:B$11,)))