jcst.net
当前位置:首页 >> =SUMPRODUCT(ShEEt2!$H$2:$H$500<45)*(ShEEt2!$B$2... >>

=SUMPRODUCT(ShEEt2!$H$2:$H$500<45)*(ShEEt2!$B$2...

=SUMPRODUCT((录入数据!$B$7:$B$4000

有问题 $M6:$M21

假设A列是月份,B列是总销量 则在K2中输入如下公式: =COUNTIF(B:B,"

网站首页 | 网站地图
All rights reserved Powered by www.jcst.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com