您好,我有个EXCEL的问题想问您,请查看附加的图片,我想要在方框中填入相应的数字。

2025-02-26 06:05:05
推荐回答(2个)
回答1:

G11=SUMPRODUCT(($B$2:$B$7=$F11)*($C$2:$C$7=G$10)*($D$2:$D$7))
向右向下拉

回答2:

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