1、首先在单元格中输入:=sumifs ——回车——点击上面的【插入函数】标志:fx。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9d82d158ccbf6c817dbb87e1b33eb13533fa402f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、求和区域:用于求和计算的数据区域
选择要计算的数据区域。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6f061d950a7b02080e0a94e86dd9f2d3562cc8fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、区域1:第一个条件判断所处的区域
选择条件所处的区域。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/14ce36d3d539b60094e8a4bee650352ac65cb791?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、如图中要求是:求级别好的苹果总销量。所以这里有两个条件要求:一是“苹果”;二是级别为“好”。区域1选择的是品种的区域,条件1与区域1相对应。所以条件1输入:苹果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cb8065380cd791232bf83e7da2345982b2b7809b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、区域2与条件2是另一条件的操作,方法与区域1和条件2一样,输入相应的内容便可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2fdfc039245d688f43b18adabc27d1ed21b24f9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、点击右边的滚动条可以看到:区域3、4、5……;条件3、4、5……等等,满足更多条件筛选的要求,最后点击【确定】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9f2f070828381f30850c27a0a6014c086e06f0a6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、完成效果图。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e850352ac65c1038e03d64cbbd119313b07e897c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)