G11=SUMPRODUCT(($B$2:$B$7=$F11)*($C$2:$C$7=G$10)*($D$2:$D$7))向右向下拉
G11输入=SUMPRODUCT(($A$2:$A$7=$E11)*($B$2:$B$7=$F11)*($C$2:$C$7=G$10),($D$2:$D$7))先向右填充到I11再向下填充。