用公式进行多条件求和
10-15 21:47:25
来源:http://www.qz26.com Excel教程 阅读:8795次
导读: 1.计算出7月份广州的总销量: =SUMIFS($F$2:$F$23,$A$2:$A$23,"7月",$B$2:$B$23,"广州") 2.计算出7月和10月拖鞋总销量: =SUMIFS($F$2:$F$23,$A$2:$A$23,"7月",$C$2:$C$23,"拖鞋")+SUMIFS($F$2:$F$23,$A$2:$A$23,"10月",$C$2:$C$23,"拖鞋") 3.计算出7-10月武汉男式袜子销量: =SUMIFS($F$2:$F$23,$B$2:$B$23,"武汉",$C$2:$C$23,"袜子",$E$2:$E$23,"男")单击右侧链接打开示例文件下载页面:多条件求和示例.xls 点击下载此文件 上一页 [1] [2]
用公式进行多条件求和,标签:Excel学习,excel视频教程,http://www.qz26.com
1.计算出7月份广州的总销量:
1.计算出7月份广州的总销量:
=SUMIFS($F$2:$F$23,$A$2:$A$23,"7月",$B$2:$B$23,"广州")
2.计算出7月和10月拖鞋总销量:
=SUMIFS($F$2:$F$23,$A$2:$A$23,"7月",$C$2:$C$23,"拖鞋")+SUMIFS($F$2:$F$23,$A$2:$A$23,"10月",$C$2:$C$23,"拖鞋")
3.计算出7-10月武汉男式袜子销量:
=SUMIFS($F$2:$F$23,$B$2:$B$23,"武汉",$C$2:$C$23,"袜子",$E$2:$E$23,"男")
单击右侧链接打开示例文件下载页面:多条件求和示例.xls 点击下载此文件
Tag:Excel教程,Excel学习,excel视频教程,电脑培训学习 - 办公软件学习 - Excel教程