excel函数查找引用相关问题请
说明:
1、自B4开始选中B4:F7,输入公式“=SUMPRODUCT((Sheet1!$A$2:$A$21=$A4)*(Sheet1!$B$2:$B$21=B$2)*Sheet1!$C$2:$C$21)”,点CTR+LENTER键,或按住填充柄将B4公式复制到全区,结果如黄色区域。
2、B4还可用“{=SUM((Sheet1!$A$2:$A$21=$A4)*(Sheet1!$B$2:$B$21=B$2)*Sheet1!$C$2:$C$21)}”、“{=SUM(IF((Sheet1!$A$2:$A$21=$A4)*(Sheet1!$B$2:$B$21=B$2),Sheet1!$C$2:...全部
说明:
1、自B4开始选中B4:F7,输入公式“=SUMPRODUCT((Sheet1!$A$2:$A$21=$A4)*(Sheet1!$B$2:$B$21=B$2)*Sheet1!$C$2:$C$21)”,点CTR+LENTER键,或按住填充柄将B4公式复制到全区,结果如黄色区域。
2、B4还可用“{=SUM((Sheet1!$A$2:$A$21=$A4)*(Sheet1!$B$2:$B$21=B$2)*Sheet1!$C$2:$C$21)}”、“{=SUM(IF((Sheet1!$A$2:$A$21=$A4)*(Sheet1!$B$2:$B$21=B$2),Sheet1!$C$2:$C$21))}”公式,可得到与1相同结果。
3、2使用的是数组公式,应将光标置于编辑栏,点CTRL+SHIFT+ENTER键以嵌套{}符号。收起