指定商品 月份 客人數 (12668)

G2:H4=SUMPRODUCT((MONTH($B$2:$B$16)-LEFTB(G$1,2)=0)*($D$2:$D$16=$F2))

G9:H11{=SUM((MATCH(MONTH($B$2:$B$16)&$C$2:$C$16&$D$2:$D$16,MONTH($B$2:$B$16)&$C$2:$C$16&$D$2:$D$16,)=ROW($1:$15))*($D$2:$D$16=$F9)*(MONTH($B$2:$B$16)-LEFTB(G$8,2)=0))