購買明細 計算總價 (12700)

C2{=SUM(RIGHT(SMALL((1-ISERR(FIND(F$2:F$9&IF(COLUMN(A:Z)=1,"","*"&COLUMN(A:Z)),B2)))*COLUMN(A:Z)+ROW(2:9)/1%,ROW($1:$8)*26),2)*G$2:G$9)