打开数据原表,选择求和区域
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d53f8794a4c27d1ea8f746a50bd5ad6edcc438f9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
方法一:通过快速点击自动求和,来计算求和得出结果
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9345d688d43f8794dc2e354fc21b0ef41ad53af9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
方法二:通过使用求和快捷键alt+=来进行求和,鼠标定位在求和所在列的后一个单元格,用鼠标按Ctrl不放,然后按住等于号“=”,松开后即可得出求和结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2cec3fdfc039245a3649c6e9794a4c27c1e25f9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
方法三:直接在求和所在列的后一个单元格中输入“=SUM(求和区域)”,然后回车即可得到结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d788d43f8794a4c204f29a4a1ef41bd5ac6e39f9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
方法四:可在后续数据表中为了计算方便,可以使用名称管理器,构建名称进行计算。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2fdfc039245d688a2d3cfc5b4c27d1ed31b24f9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c9fcc3cec3fdfc03e6a99ed9c43f8794a5c226f9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述