为什么sumproduct值为0?=SUMPRODUCT((Total!$B$2:$B$10000=2010)*(Total!$C$2:$C$10000=11)*(Total!$C$2:$C$10000=$A2)*Total!$L$2:$L$10000)我要筛选年,月,代码,然后求和,之前这么做过没有问题的,可是这次怎么计算结果都是0,
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/03 12:53:16
![为什么sumproduct值为0?=SUMPRODUCT((Total!$B$2:$B$10000=2010)*(Total!$C$2:$C$10000=11)*(Total!$C$2:$C$10000=$A2)*Total!$L$2:$L$10000)我要筛选年,月,代码,然后求和,之前这么做过没有问题的,可是这次怎么计算结果都是0,](/uploads/image/z/11681529-33-9.jpg?t=%E4%B8%BA%E4%BB%80%E4%B9%88sumproduct%E5%80%BC%E4%B8%BA0%3F%3DSUMPRODUCT%28%28Total%21%24B%242%3A%24B%2410000%3D2010%29%2A%28Total%21%24C%242%3A%24C%2410000%3D11%29%2A%28Total%21%24C%242%3A%24C%2410000%3D%24A2%29%2ATotal%21%24L%242%3A%24L%2410000%29%E6%88%91%E8%A6%81%E7%AD%9B%E9%80%89%E5%B9%B4%2C%E6%9C%88%2C%E4%BB%A3%E7%A0%81%2C%E7%84%B6%E5%90%8E%E6%B1%82%E5%92%8C%2C%E4%B9%8B%E5%89%8D%E8%BF%99%E4%B9%88%E5%81%9A%E8%BF%87%E6%B2%A1%E6%9C%89%E9%97%AE%E9%A2%98%E7%9A%84%2C%E5%8F%AF%E6%98%AF%E8%BF%99%E6%AC%A1%E6%80%8E%E4%B9%88%E8%AE%A1%E7%AE%97%E7%BB%93%E6%9E%9C%E9%83%BD%E6%98%AF0%2C)
为什么sumproduct值为0?=SUMPRODUCT((Total!$B$2:$B$10000=2010)*(Total!$C$2:$C$10000=11)*(Total!$C$2:$C$10000=$A2)*Total!$L$2:$L$10000)我要筛选年,月,代码,然后求和,之前这么做过没有问题的,可是这次怎么计算结果都是0,
为什么sumproduct值为0?
=SUMPRODUCT((Total!$B$2:$B$10000=2010)*(Total!$C$2:$C$10000=11)*(Total!$C$2:$C$10000=$A2)*Total!$L$2:$L$10000)
我要筛选年,月,代码,然后求和,之前这么做过没有问题的,可是这次怎么计算结果都是0,
为什么sumproduct值为0?=SUMPRODUCT((Total!$B$2:$B$10000=2010)*(Total!$C$2:$C$10000=11)*(Total!$C$2:$C$10000=$A2)*Total!$L$2:$L$10000)我要筛选年,月,代码,然后求和,之前这么做过没有问题的,可是这次怎么计算结果都是0,
=SUMPRODUCT((Total!$B$2:$B$10000=2010)*(Total!$C$2:$C$10000=11)*(Total!$C$2:$C$10000=$A2)*Total!$L$2:$L$10000)改为
=SUMPRODUCT((Total!$B$2:$B$10000=2010)*(Total!$C$2:$C$10000=11)*(Total!$C$2:$C$10000=$A2)*(Total!$L$2:$L$10000))
如果A2不等于11,或C列中没有等于11的数,或B列中没有等于2010的数,符合条件L列数求和也为0.