求各單價總數量 (10299)

J2:J5{=SUM((MMULT(N(F$3:F$16/TRANSPOSE(I$2:I$5)=E$3:E$16),{1;2;3;4})=ROW(A1))*E$3:E$16)

M3=SUM(E3:E16)

M4=SUM(J2:J5)