1、打开excel,将需要处理的数据输入。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/314e251f95cad1c8790a0522703e6709c93d5106?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、单击C3单元格,输入公式=SUMPRODUCT((A$2:A$3000>B2)*(A$2:A$3000<B3))获得第一个符合条件的个数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d833c895d143ad4bc06abfc58d025aafa40f066a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、下拉C3公式,获取所有符合条件的个数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/37d12f2eb9389b50e69619578a35e5dde7116e4e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在D3输入公式=COUNTIFS(A$2:A$22,">"&D2,A$2:A$22,"<"&D3),这里值得注意的是,大于号后面,如果是数值,不用用&,如果是单元格值,必须用&链接。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fc1f4134970a304efead59ffdec8a786c9175c2c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、下拉D3公式,得到所有值。这样就成功的将excel countif条件设置为大于某个单元格数字。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a469aac723c6463f6246b60af2d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)