sheet1中查找同时满足多个条件的值,在sheet2中显示

你的截图缺少行列号！请看效果图：J2输入公式：=SUMPRODUCT((Sheet1!$A$2:$A$8=G2)*(Sheet1!$B$2:$B$8=H2)*(Sheet1!$C$2:$C$8=I2)*(Sheet1!$D$2:$D$8))其中sheet1的表格行列号如图（你根据实际情况做相应修改）