Excel表格求和主要有两种方法,可以利用表格内的求和工具或者是手动输入求和公式,具体操作方法如下:
一、利用表格内“求和”工具
1、首先全选在Excel表格内需要求和的数字;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd577be318e5eda81cb38db3ddf?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/d043ad4bd11373f071afb6e5ab0f4bfbfbed043c?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/fc1f4134970a304e9ef67980dec8a786c8175cf0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
二、手动输入求和公式
1、选中空白一格,在内输入求和公式“=SUM()”;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/024f78f0f736afc38561e71fbc19ebc4b745125f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、“()”括号内输入想要求和的数值,如“=SUM(C2:C14)”,请注意数值中间是冒号;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/ac4bd11373f08202ae1d484544fbfbedab641b39?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/a50f4bfbfbedab64fa9494baf836afc378311ee2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)