实现的方法和操作步骤如下:
1、首先,打开要处理的excel表单,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6c224f4a20a44623c158f31e8822720e0cf3d738?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、其次,完成上述步骤后,在表格中实现“要求出2017年入社的人数”的功能,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/622762d0f703918f1b436bb6413d269759eec438?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、接着,完成上述步骤后,在另一个单元格中输入公式“=COUNTIFS(C:C,">=日期下限值",C:C,"<=日期上限值")”,
例如“=COUNTIFS(C:C,">=2017-1-1",C:C,"<=2017-12-31")”,见下图。
如果要求大于某个日期,则将日期上限值的条件删除即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1e30e924b899a901e6a70d4a0d950a7b0208f538?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、最后,完成上述步骤后,按Enter键之后就得出要求的数量了,如下图所示。这样,问题就解决了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8ad4b31c8701a18b267944338e2f07082838fe38?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)