excel中统计一行数据里小于某个数值的个数具体步骤如下:
1.启动excel,选中D2:D6单元格,按下键盘上的ctrl+F,打开查找和替换框。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/54fbb2fb43166d22eb95a94c4d2309f79152d20c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2.在查找内容中输入*号,表示所有字符,可以是一个也可以是多个,单机查找全部按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0eb30f2442a7d9339caf5baba64bd11372f001e6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3.此时下方提示五个单元格被找到,单击值,将值按照从小到大排列,选中数值小于70的,也就是先前规定不合格的几项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a1ec08fa513d2697c45ab7855efbb2fb4216d859?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/c83d70cf3bc79f3dd4365be8b1a1cd11738b2916?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5.这样源数字表格里面不符合要求的数据(低于70)就会被替换为不合格,清清楚楚的显示出来。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cf1b9d16fdfaaf51095b3f67875494eef11f7aaa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳