按照如下步骤即可在excel中筛选一列中大于某个数值的数量:
1、首先在excel中插入一个表格,选中A列区域。
![](https://iknow-pic.cdn.bcebos.com/3b87e950352ac65cb588fe02f5f2b21193138a36?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后点击开始工具栏中的排序和筛选,点击筛选。
![](https://iknow-pic.cdn.bcebos.com/4bed2e738bd4b31cd0d20cca89d6277f9f2ff8d1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、点击筛选后,在第一行单元格旁就会有一个下拉箭头,因为只需要筛选甲对应的数据,所以只选中甲。
![](https://iknow-pic.cdn.bcebos.com/1f178a82b9014a90be3eddcca7773912b31beebb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、然后就可以看到单元格中只有甲的数据了。
![](https://iknow-pic.cdn.bcebos.com/0dd7912397dda1441dabf7c3bcb7d0a20cf48625?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、然后鼠标移至旁边的空白单元格,点击插入函数,再选择COUNTIF函数,点击确定。
![](https://iknow-pic.cdn.bcebos.com/b3fb43166d224f4a5d4fe86207f790529922d1e9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、在弹出的对话框中,第一个文本框输入要筛选的区域,第二个文本框输入筛选的条件,即“>=10”,点击确定。
![](https://iknow-pic.cdn.bcebos.com/42a98226cffc1e17ce4316404490f603728de9c7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、可以看到单元格中就显示出了大于10的数据个数。
![](https://iknow-pic.cdn.bcebos.com/d62a6059252dd42abca884da0d3b5bb5c9eab81a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)