关于excel函数公式问题请指点SUMPRODUCT((Sheet2!C4:C18="Sheet1!B1")*(Sheet2!D4:D18="Sheet1!b4")*Shee这是表1这是表2 计算结果在表2 的C4=SUMPRODUCT((Sheet2!C4:C18="Sheet1!B1")*(Sheet2!D4:D18="Sheet1!b4")*Sheet
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/12 01:30:37
![关于excel函数公式问题请指点SUMPRODUCT((Sheet2!C4:C18=](/uploads/image/z/7012809-9-9.jpg?t=%E5%85%B3%E4%BA%8Eexcel%E5%87%BD%E6%95%B0%E5%85%AC%E5%BC%8F%E9%97%AE%E9%A2%98%E8%AF%B7%E6%8C%87%E7%82%B9SUMPRODUCT%28%28Sheet2%21C4%3AC18%3D%22Sheet1%21B1%22%29%2A%28Sheet2%21D4%3AD18%3D%22Sheet1%21b4%22%29%2AShee%E8%BF%99%E6%98%AF%E8%A1%A81%E8%BF%99%E6%98%AF%E8%A1%A82+%E8%AE%A1%E7%AE%97%E7%BB%93%E6%9E%9C%E5%9C%A8%E8%A1%A82+%E7%9A%84C4%EF%BC%9DSUMPRODUCT%28%28Sheet2%21C4%3AC18%3D%26quot%3BSheet1%21B1%26quot%3B%29%2A%28Sheet2%21D4%3AD18%3D%26quot%3BSheet1%21b4%26quot%3B%29%2ASheet)
关于excel函数公式问题请指点SUMPRODUCT((Sheet2!C4:C18="Sheet1!B1")*(Sheet2!D4:D18="Sheet1!b4")*Shee这是表1这是表2 计算结果在表2 的C4=SUMPRODUCT((Sheet2!C4:C18="Sheet1!B1")*(Sheet2!D4:D18="Sheet1!b4")*Sheet
关于excel函数公式问题请指点SUMPRODUCT((Sheet2!C4:C18="Sheet1!B1")*(Sheet2!D4:D18="Sheet1!b4")*Shee
这是表1
这是表2
计算结果在表2 的C4=SUMPRODUCT((Sheet2!C4:C18="Sheet1!B1")*(Sheet2!D4:D18="Sheet1!b4")*Sheet2!E4:E18)
关于excel函数公式问题请指点SUMPRODUCT((Sheet2!C4:C18="Sheet1!B1")*(Sheet2!D4:D18="Sheet1!b4")*Shee这是表1这是表2 计算结果在表2 的C4=SUMPRODUCT((Sheet2!C4:C18="Sheet1!B1")*(Sheet2!D4:D18="Sheet1!b4")*Sheet
=SUMPRODUCT((Sheet1!$C$4:$C$18=$B$2)*(Sheet1!$D$4:$D$18=$B4)*Sheet1!$E$4:$E$18)
或
=SUMPRODUCT((Sheet2!$C$4:$C$18=$B$2)*(Sheet2!$D$4:$D$18=$B4)*Sheet2!$E$4:$E$18)
不晓得你两图到底谁Sheet1,所以写了两个