1、本次操作演示使用的Office办公软件为Excel 2013版本。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9922720e0cf3d7cae7769db8fc1fbe096a63a978?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、新建一个Excel电子表格,表格用于演示如何将一列数据求和的操作设置。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fd039245d688d43fa0cd3e3c731ed21b0ff43b93?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/3c6d55fbb2fb4316e318d4b42ea4462308f7d3fd?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/cb8065380cd7912355203bbaa3345982b3b78038?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、这时可以看到Excel表格已经自动选取了一列的数据,(注:也可在函数编辑栏内输入"=SUM(A:A)"公式,求和区域根据需求选定)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4ec2d5628535e5dd38710b1178c6a7efcf1b629b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、最后单击键盘上的回车键即可得出总和,这样Excel中的一列数据的求和操作就完成了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/30adcbef76094b3660d2b523adcc7cd98c109db8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)