以2007版EXCEL为例,计算下图中的总销售额
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1efef78b65a2c11dfa9ecce58?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
方法一:运用菜单栏上的自动求和来计算总金额
1、选中销售金额F2到F20的区域
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/83025aafa40f4bfba09b21010e4f78f0f736181f?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/f636afc379310a55d1d160a1ba4543a9832610e9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、完成,计算结果自动显示在选择区域下的第一个单元格,即F21,如下图
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e824b899a9014c08e8db96f0077b02087af4f487?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
方法二:运用求和函数SUM计算总金额
1、在销售金额列最后一个单元格后的单元格(即F21)输入:=sum()
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2e2eb9389b504fc23e3a0850e8dde71190ef6d7a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、将光标移动到sum函数的括号内
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/38dbb6fd5266d0164a64267d9a2bd40735fa3561?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、用鼠标选择需要求和的区域,即F2到F20,如下图
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/aec379310a55b3198a623a204ea98226cefc17cf?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/8ad4b31c8701a18bfd0daa1a932f07082938fe85?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)