# Excel 各样求和技巧，你不可不晓得-天涯论坛

nykek5i 发表于 2024-10-1 07:47:08

# Excel 各样求和技巧，你不可不晓得

<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"># Excel <span style="color: black;">各样</span>求和技巧，你<span style="color: black;">不可</span>不<span style="color: black;">晓得</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">段子手168</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">## <span style="color: black;">1、</span>快速求和快捷键：Alt + =</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 1、<span style="color: black;">运用</span><span style="color: black;">办法</span>：选中区域数据，按 Alt 和 = 组合键，快速得出求和结果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 2、示例：</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/ba8c29be06e74b3cb2e2db78fe2726ac~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=4og71RjmK5WiYLBXx8qCCmZg1Po%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 3、<span style="color: black;">倘若</span>多选出右侧空白单元格，<span style="color: black;">而后</span>再按 Alt 和 = 组合键，会在右侧空白单元格快速得出求和结果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 4、示例：</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/22e3781305c04b929f5b6d162718489b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=F3r1OEASoAOvDwlKTzr%2FK24ehpk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5ebf7349d2964e9d9676495b20471a92~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=eA2AFQ%2FAQc30uHeOFagkl5KgRlM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 5、<span style="color: black;">倘若</span>多选出下边空白单元格，<span style="color: black;">而后</span>再按 Alt 和 = 组合键，会在下边空白单元格快速得出求和结果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 6、示例：</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/dfd7617d097e453595596cdef9d893e5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=sxlTJWK849Oc155k%2BkIbgdLM1Uo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/42130f82c559436696a1d36b8aafe97f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=qaKgiYDNCsADakephWJM4MY3LGk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 7、<span style="color: black;">倘若</span>多选出右侧和下边空白单元格，<span style="color: black;">而后</span>再按 Alt 和 = 组合键，会在右侧和下边空白单元格，都快速得出求和结果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 8、示例：</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f64b878a292b453bb040bd52ae9cf47f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=0BwCtVTuxaV7GVDPe%2Bor49qyTwE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/28de11dac6fa4f329583db19e4a1c50e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=m7O8c74Tvf%2BIe3Ki1nKZpDwprXU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">## <span style="color: black;">2、</span>多个区域快速求和：SUM(A1:A6,B1:B10,C1:C20) Ctrl + G 快速定位，Alt + = 快速求和。</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 1、<span style="color: black;">运用</span><span style="color: black;">办法</span>：<span style="color: black;">运用</span> Ctrl 组合键，选中多个区域数据，按 Alt 和 = 组合键，快速得出各个区域分别的求和结果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 2、示例：</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/21956e80c70c4366bfe59f1b287aea64~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=dsNDQ34slz02YKYPJgAD7vzZLhI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/71e5d91ef99a4b44b4825e8e25e695c5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=esT1SkHcbB%2BjC2Z6oxUUX2H9amQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 3、<span style="color: black;">运用</span><span style="color: black;">办法</span>：选中一单元格，点击求和函数 SUM，<span style="color: black;">而后</span><span style="color: black;">运用</span> Ctrl 组合键，选中多个区域数据，按 Enter 回车键，快速得出各个区域总的求和结果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 4、示例：</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/74fd90b907804f6da7f36ca00ca8d15b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=hhXckQzrwY1Ku7kHfw2iQC%2Fa6MI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/efe65f2459a747059e138d4e778e2c0c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=W3gUWM4u6p6BrtvEZ5MsZNB0Pjg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 5、快速在右侧得出求和结果，全选多区域单元格和空白格，按Alt 和 = 组合键，快速得出各个区域分别的求和结果，<span style="color: black;">然则</span>中间的下边无求和结果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 6、示例：</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f21ac4c904ab4e2994ab30d49172502f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=33%2B01xws%2F4l2hOUi%2BR1ytJm0eUg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/21d968c99f38430985b1ae7df841de61~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=GHxH%2FCLiXm0qVuf0bVMtVnApdMw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 7、快速在右侧和下边都得出求和结果：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1）全选多区域单元格和空白格，</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2）按Ctrl 和 G 组合键，快速打开【定位】，参数<span style="color: black;">选取</span>【空值】，点击【确定】。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3）再次按Alt 和 = 组合键，快速得出各个区域右侧和下边的求和结果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 8、示例：</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b4fcfefe22c1417f9d72624722fb2be3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=VVtG%2FjH9SNbpIeG3BBSyNROvBxY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6923c19bb01d4214b49f28cfd881e11f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=sqluCxu8uyAdE7D33WPqxAMmgeY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/82eda9b2a69c4a87b69f715a25a96176~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=d1PWJsUPTXuGIdq3yz8cD%2Bl2T2w%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">## <span style="color: black;">3、</span>带有字符或文字的单元格数据求和：a=xxx1+xxx2+xxx3+... 替换 a= 为 =</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 1、<span style="color: black;">运用</span><span style="color: black;">办法</span>：先把一个带有字符或文字的单元格中数字累加，a=xxx1+xxx2+xxx3+...</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">如：a=1000+80000</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 2、<span style="color: black;">运用</span> Ctrl + E 快速向下填充，复制公式，<span style="color: black;">运用</span>多个单元格公式一样。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 3、选中多个单元格，按 Ctrl + H 打开【<span style="color: black;">查询</span>替换】，点击【替换】，<span style="color: black;">查询</span>内容【a=】，替换内容【=】，点击【确定】，就<span style="color: black;">所有</span>求各成功。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 4、示例：</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/06b760235a8948079e369ca3036f0f14~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=cxDSlp3AHEeHwtckSoQlZue%2BUqE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/85eb71b3eefa4c67a8c18f261b0d1c16~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=G%2BZd2L7lA62dyDQT1QmbtwXDTI4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8c3349ed9af14e80bd9429b63f64c5e1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=w5brw4vYJJmkUPP%2BzF5b0huJBvs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/fb8d7f56172f461db8220d7cb4444eb3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=W0lRb2PYhOjX5jv2or7WhNdPuPU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">## <span style="color: black;">4、</span>按单元格颜色求和：</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 1、随便选中一个单元格，<span style="color: black;">运用</span> Ctrl + F 组合键，打开【<span style="color: black;">查询</span>替换】，点击【选项】，再点击【格式】，【背景颜色】，<span style="color: black;">此时</span>【鼠标】变为【吸管】样式。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/48b1e1f84f3b4480a1255dee5cebe9d3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=dK7pHIcRs8TrweOAQBWdzFEqTvg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 2、用【吸管鼠标】点击【黄色单元格】。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/217f8d214804441e90916c99986c6bd9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=EHmuCM1UXG%2B4JW8%2FY%2FdL%2BQ9%2FaZE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 3、点击【<span style="color: black;">所有</span><span style="color: black;">查询</span>】，按 Ctrl + A 组合键，全选中<span style="color: black;">查询</span>出来的多个单元格，点击【关闭】。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/07872135bce643d3a4f28e2870e3459d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=3IJ1gTOjEEmBoK5dVOTyuwDHA4o%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 4、点击 excel 的菜单栏【公式】，再点击【名<span style="color: black;">叫作</span>管理器】，点击【新建】。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/27fe16a329484d47ad7edca862e33dc8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=eiAIMunobMdq9KPz%2F12bB4FpoW0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 5、名<span style="color: black;">叫作</span>输入【黄色】，点击【确定】，再点击【关闭】。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e42278e5b94c4fedb8c2ac5127a300d2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=IbsEPFrRA7wQGcqMvV%2Bd9rymKVQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/4ae9cb9580154291beb102e23ee7ff90~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=xBB2gcYOkRuyq0QiasZWaVvpdWA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">### 6、<span style="color: black;">而后</span>点击需<span style="color: black;">需求</span>和的单元格，如【黄色求和】下面的【F5】单元格。在函数框里输入：=SUM(黄色) 点击【确定】对号。就成功求和。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/d74059dc6d98475d9d43bb954c9ef4a3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=JmQpqcbsA9e64Gn5rq6Q5aSjdWU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/d251326c4503404f85a90a0c4beb8f54~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948484&x-signature=3pQQ2xNQHClsw0oER%2FaXBrudZwU%3D" style="width: 50%; margin-bottom: 20px;"></div>

qzmjef 发表于 2024-10-9 23:56:42

感谢楼主分享，祝愿外链论坛越办越好！

m5k1umn 发表于 2024-10-16 10:07:43

感谢你的精彩评论，带给我新的思考角度。

b1gc8v 发表于 2024-10-17 15:06:16

感谢您的精彩评论，为我带来了新的思考角度。

1fy07h 发表于 2024-10-25 20:30:13

论坛的成功是建立在我们诚恳、务实、高效、创新和团结合作基础上，我们要把这种精神传递下去。

页: [1]

天涯论坛's Archiver

# Excel 各样求和技巧，你不可不晓得