excel求和方式如下:
1、打开excel表格;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0ff41bd5ad6eddc475a520692bdbb6fd536633e5?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/dcc451da81cb39db9182f3c4c2160924aa1830e5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在空白单元格中输入=sum函数,双击sum函数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b7fd5266d016092480673689c60735fae7cd34e5?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/aa18972bd40735fac9b2da2b8c510fb30e2408e5?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/e7cd7b899e510fb33c5be305cb33c895d0430ce5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、也可以用SUBTOTAL函数进行动态求和,在空白单元格输入=SUBTOTAL(109,),选中需要求和范围,按键盘上的ent键。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0e2442a7d933c895e63c0ce9c31373f0830200e5?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/d833c895d143ad4be86cd25290025aafa50f06e5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
也可以隐藏其中几项,SUBTOTAL函数会自动屏蔽隐藏项进行求和。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d043ad4bd11373f0b97dfb0db60f4bfbfaed04e5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、用sumif函数可以按条件求和,如图两种产品。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/72f082025aafa40f75845a4fb964034f79f019e5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
需要求的两种产品各自的总销量,在需要求和的单元格输入=sumif(“名称范围”,“需要求和的产品名称”,“需要筛选的数据”)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a50f4bfbfbedab644230d952e536afc378311ee5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
【加入社群一起学习】想要了解更多关于excel的相关信息,推荐咨询秒可职场。秒可职场将持续投入产品与课程内容的研发升级,积极拓展更多前沿职场课程,并开拓B端企业培训服务市场。“秒”代表“分秒、时刻”,“可”代表“可以、认可”,秒可致力于帮助广大职场人终身学习成长、获得认可和成就,实现共同富裕。