小山村情怀
高能答主
2022-11-07
·
活首一切都是最好的安排
关注
excel表格计数公式用法
材料/工具
EXCEL表格
方法
1、首先打开excel软件并输入相关信息。
![](https://iknow-pic.cdn.bcebos.com/9213b07eca806538b829338685dda144ac348260?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/0df3d7ca7bcb0a467de11cac7963f6246a60af60?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/8718367adab44aed758d2971a11c8701a08bfb60?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/d50735fae6cd7b89aeafad161d2442a7d8330e67?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、然后勾选区域。
![](https://iknow-pic.cdn.bcebos.com/241f95cad1c8a786cfe9dd9b7509c93d71cf5067?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、最后敲击回车就完成了。
![](https://iknow-pic.cdn.bcebos.com/8435e5dde71190efa03b054adc1b9d16fcfa6067?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
收起
新科技17
2022-07-26
·
TA获得超过5685个赞
知道小有建树答主
回答量:355
采纳率:100%
帮助的人:65.7万
关注
- 01
首先,打开EXCEL,并找到需要需要计数的表格并打开
- 02
将光标放在需要计数的那一列的末尾,注意不要留空格,如下图:
- 03
打开“公式”选项卡,找到“自动求和”下拉菜单中的“计数”,并单击
- 04
检查自动框选的范围是否正确
- 05
检查无误后,按下“enetr”键,计数就做好了!
-
收起
为你推荐: