excel考勤表有文字和数字应该用什么函数:使用正常的函数计算公式,下拉后选择替换即可计算。
工具/原料:
雷神DESKTOP-ABUINPS
Windows10
WPS Office办公软件2019
1、在合计单元格下输入a=10+20+30公式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f703738da97739123500c0f0ea198618367ae279?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/a8773912b31bb0517002f6b9247adab44aede079?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、输入CTRL+E快捷键。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f9198618367adab4c6f65ed299d4b31c8701e479?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/2f738bd4b31c87013090f777357f9e2f0708ff79?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、快捷键输入CTRL+H,弹出【替换】框。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/060828381f30e9242182d9a05e086e061d95f779?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、查找内容栏输入字母a。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1e30e924b899a901d7131ea70f950a7b0208f579?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、点击全部替换。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8b13632762d0f7033a94d04d1afa513d2697c579?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、显示已经9处替换。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/63d0f703918fa0eca5e1219c349759ee3d6ddb79?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
9、关闭【替换】框。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f31fbe096b63f624ae7b7c929544ebf81a4ca379?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
10、excel表格上合计栏已经成功求和了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6a600c338744ebf8d35721aecbf9d72a6059a779?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)