次數 多條件重複計 1 (11609)

H4:I6=SUMPRODUCT(($C$2:$C$21=$G4)*($D$2:$D$21=$H$2)*($B$2:$B$21=H$3)/COUNTIFS($A:$A,$A$2:$A$21,$B:$B,$B$2:$B$21,$D:$D,$D$2:$D$21,$C:$C,$C$2:$C$21))