統計食材數量 依点菜份數 (14437)

H2 下拉{=INDEX(B:B,MIN(IF(COUNTIF(E$2:E$9,A$2:A$99)*(COUNTIF(H$1:H1,$B$2:$B$99)=0),ROW($2:$99),99)))&""

I2 下拉{=IF(H2="","",SUM((B$2:B$99=H2)*MMULT((A$2:A$99=TRANSPOSE(E$2:E$9))*C$2:C$99,F$2:F$9*1)))

数量(輔助)  菜名重複有誤 D2=IFERROR(VLOOKUP(A2,E:F,2,)*C2,)

数量 J2=IF(H2="","",SUMIF(B:B,H2,D:D))