客戶底下數據 計算總額 (14235)

E2:E4{=SUM(MMULT(N(+B$2:B$18)*(LOOKUP(ROW(2:18),ROW(2:18)/(A$2:A$18=A$2),B$2:B$18)=D2)*ISNUMBER(FIND(TRANSPOSE(A$4:A$6),A$2:A$18)),{1;-1;-1}))*VLOOKUP(A$3,OFFSET(A$1,MATCH(D2,B:B,),,9,2),2,)