1、演示使用的办公软件office Excel,使用的版本为家庭和学生版2016。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/ca1349540923dd54360da606df09b3de9c824865?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、首先打开Excel电子表格并在表格中输入用于在Excel中筛选出某范围内符合某条件数字个数的操作所需要数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/902397dda144ad3472af86e9dea20cf431ad854f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、选定结果单元格后输入“=SUM(COUNTIF(C1:D5,"<="&{81,90})*{-1,1})”,该公式表示得到数据在81-90之间的个数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d000baa1cd11728b3957834cc6fcc3cec3fd2c61?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/d439b6003af33a87fc2f0f74c85c10385343b519?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、如果想要求成绩在61~80之间的人数,只需要改变求值范围,即输入“=SUM(COUNTIF(C1:D5,"<="&{61,80})*{-1,1})”即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/500fd9f9d72a60592da2ee742634349b033bba29?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)