總销量 各產品 (11868)

I2{=SUMIF(A:A,H2,B:B)+SUM(MMULT((A$2:A$8=TRANSPOSE(LOOKUP(ROW($2:$10),ROW($2:$10)/(D$2:D$10<>""),D$2:D$10)))*TRANSPOSE(E$2:E$10=H2),F$2:F$10)*B$2:B$8)