可以利用表格中的sum公式进行求和计算,以Excel 2016为例,有以下步骤:
1、打开一个Excel表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a71ea8d3fd1f413426e2c4082a1f95cad0c85eeb?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/77094b36acaf2eddd730889f821001e938019387?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在要计算结果的单元格输入等于号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/024f78f0f736afc38cd7fe13bc19ebc4b64512e9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、选择上方的公式类型,选择SUM。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b2de9c82d158ccbfc986754c16d8bc3eb135418a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、在弹出的窗体中确认计算范围。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cb8065380cd79123f1d25402a2345982b2b78092?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、点击确认后返回看到结算结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3801213fb80e7bec281bc297202eb9389a506b87?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/d6ca7bcb0a46f21fffc69f25f9246b600d33aed2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
注意事项:
1、如果存在隐藏行,而实际又不需要计算隐藏数据的话,直接使用自动求和按钮就会得到错误值。
2、一列数据如果存在合并单元格,直接单击自动求和按钮得不到正确结果。
3、整列的数字中,如果混有一个文本格式的数字,就破坏了数据的连续性,就会导致自动求和出错。
本回答被网友采纳