材料/工具:Excel2010
1、如图ABCDE为原始数据,想要分单位统计对应条件的人数显示到对应列位置。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9825bc315c6034a814e9c9e7c513495409237648?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、点击插入函数功能按钮。选择数学与三角函数,中的SUMPRODUCT,点击确定
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8694a4c27d1ed21b8fc65f83a36eddc451da3f4c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、弹出函数参数设置框,注意这个函数的基本说明是返回相应的数组或区域乘机的和。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/86d6277f9e2f0708ee0d5b66e724b899a901f248?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、需要将条件都写到第一行的输入框中基本格式为(条件一)*(条件二).....
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/024f78f0f736afc3df594e03bd19ebc4b745127a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、为了让公式在向右、向下拖动中,自动计算对应列的正确单元格,需要合理加上绝对引用$。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/ac345982b2b7d0a212bc75fbc5ef76094b369a5a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、完成计算后,会看到正确结果。拖动公式到合适位置 I列。即可计算符合条件的男女的人数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e824b899a9014c08a29559c3047b02087bf4f42e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)