为什么exel表用sumproduct公式,有的数取得对有的数取不对,明明格式都一样啊office2007,公式=SUMPRODUCT((烟台473!B$2:B$2000=C6)*(烟台473!C$2:烟台473!C$2000=D6)*(烟台473!D$2:烟台473!D$2000=F6)*烟台473!E$2:烟台473!E$
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/12 02:21:14
![为什么exel表用sumproduct公式,有的数取得对有的数取不对,明明格式都一样啊office2007,公式=SUMPRODUCT((烟台473!B$2:B$2000=C6)*(烟台473!C$2:烟台473!C$2000=D6)*(烟台473!D$2:烟台473!D$2000=F6)*烟台473!E$2:烟台473!E$](/uploads/image/z/13639713-33-3.jpg?t=%E4%B8%BA%E4%BB%80%E4%B9%88exel%E8%A1%A8%E7%94%A8sumproduct%E5%85%AC%E5%BC%8F%2C%E6%9C%89%E7%9A%84%E6%95%B0%E5%8F%96%E5%BE%97%E5%AF%B9%E6%9C%89%E7%9A%84%E6%95%B0%E5%8F%96%E4%B8%8D%E5%AF%B9%2C%E6%98%8E%E6%98%8E%E6%A0%BC%E5%BC%8F%E9%83%BD%E4%B8%80%E6%A0%B7%E5%95%8Aoffice2007%2C%E5%85%AC%E5%BC%8F%3DSUMPRODUCT%28%28%E7%83%9F%E5%8F%B0473%21B%242%3AB%242000%3DC6%29%2A%28%E7%83%9F%E5%8F%B0473%21C%242%3A%E7%83%9F%E5%8F%B0473%21C%242000%3DD6%29%2A%28%E7%83%9F%E5%8F%B0473%21D%242%3A%E7%83%9F%E5%8F%B0473%21D%242000%3DF6%29%2A%E7%83%9F%E5%8F%B0473%21E%242%3A%E7%83%9F%E5%8F%B0473%21E%24)
xTNA~$iYr!;Q6;
R+")
CMJԄ^fg}g[H3&Zu:cU5o;dؘS4v@20ٹcYyZX4ثyV4fϭʌyBsaa" zZOF