材料/工具:Excel2010
1、选择要求和的单元格,点击编辑栏的插入函数符号
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/09fa513d269759ee222b53a0bcfb43166d22df65?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、进入插入函数页面,在查找函数框里面输入:sumifs,选择函数列表里面的:SUMIFS点击下面的【确定】
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b151f8198618367a23bb4cb620738bd4b31ce5af?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在函数参数页面,求和区域框选择金额一列:C2:C13
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8ec8a13632762d0ef3a97d4aeec08fa513dc650?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、第一个条件是1班级所以在区域1里面输入班级列:B2:B13
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1b4c510fd9f9d72a5b3d2376da2a2834349bbb7b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、相应的条件1直接输入:1,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/35a85edf8db1cb13c23c0f78d354564e92584b07?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、第二个条件是男生,所以在区域2里面输入性别列:A2:A13
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d439b6003af33a87a0093371c85c10385343b570?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、条件2输入:"男"条件为中文是要用英文状态下的双引号,如果是数值的话直接输入数字就可以
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d31b0ef41bd5ad6e1f6757818fcb39dbb6fd3c3a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、输完函数参数后,点击【确定】回到表格后,可以看到值已经算出来了
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/eaf81a4c510fd9f9edac66022b2dd42a2834a425?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)