做为数据处理能手：Excel中快速求和与求平均数的绝招！
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">Excel快速求和你用过吗？</span></span><span style="color: black;"><span style="color: black;">快速求和是一个非常常用且实用的功能，<span style="color: black;">能够</span><span style="color: black;">帮忙</span><span style="color: black;">咱们</span><span style="color: black;">容易</span>地对一系列数字进行加总计算。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/b2478286a54343ee822ac774ae357dd7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=Wns3nHTDT5HF1gVeq64QHuXEsIY%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;"><span style="color: black;">这个表格中，要对消费金额进行求和，<span style="color: black;">一般</span><span style="color: black;">状况</span>下是<span style="color: black;">运用</span>求和函数进行计算，但你会<span style="color: black;">发掘</span><span style="color: black;">有些</span>大神只是按了一下键盘汇总的结果就出来了。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><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/23f652b840d74d138e5a92d7299fe092~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=Pbb%2FBVypouTYLVlnNlZE4nm5maA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">快速求和</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">此刻</span>就来揭秘这个小技巧，<span style="color: black;">因为</span>求和运算比较常用，<span style="color: black;">因此</span>Excel中悄悄设置了一个快捷按键：</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">ALT=</span></span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/09374b72e6bc483b97fce8867d4976b4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=x3GvQBkFPLKVrZfaQCunv7jLq7Q%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;"><span style="color: black;">选中D6单元格，<span style="color: black;">咱们</span>要计算上方一系列数字的和，<span style="color: black;">能够</span>按下ALT键不放，再按一下等号键，结果就出来了，<span style="color: black;">便是</span>这么简单。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2b2a6db0e27c4a77bb886f3af54921e0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=H%2Fa3uH7936ylkim4ZrEouQAMgSk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">快速求平均数</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">那样</span>，求平均数有快捷键吗？还真<span style="color: black;">无</span>，<span style="color: black;">不外</span>，快捷操作倒是有一个，听我慢慢道来。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">选中C6单元格，<span style="color: black;">咱们</span>来计算C列这一系列数字的平均值，<span style="color: black;">一样</span>是按快捷键的方式。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">ALT M</span></span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">能够</span>看到菜单栏转到公式菜单下，并且各功能项下方<span style="color: black;">显现</span>了<span style="color: black;">有些</span>“<span style="color: black;">奥秘</span>字母”，接着敲一下字母“U”。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/9492fe7ea7c540f4b34c16e439e164ae~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=yh%2FCuFe7LWIYE0rRGLtIDFtyLqA%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;"><span style="color: black;"><span style="color: black;">能够</span>看到激活了自动求和项的下拉菜单，<span style="color: black;">这儿</span>面<span style="color: black;">包括</span>常用的“求和”、“平均值”、“计数”、“最大和最小值”以及其他函数。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">咱们</span>是要进行平均值的计算，<span style="color: black;">因此</span>继续敲一下字母“A”。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p6-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/207f31bd6846498cb1d68ecd4f8a930e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=ThbNRNVQHVqfjfSca%2FSyGoBT1Qw%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;"><span style="color: black;"><span style="color: black;">这般</span>，C2:C5的平均数就计算出来了。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/d1bc5a0abd364310a849f32ddb128c7b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=CRUZGoY3Nsjqs6T3VzMbcHvu%2FFE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">快速求最大数</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">求最大数<span style="color: black;">亦</span>是这个<span style="color: black;">办法</span>，依次按下键</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">ALT M U M</span></span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f26168d29f214f3cbb47f464314e7257~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=vEMAzg36%2BvWicoEcKHUqp6XKKOY%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;"><span style="color: black;">C2:C5单元格的最大数就被计算出来。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/127ef7b832d340f18d65ecc9a6058cba~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=8%2BuLlfvX5S0HD6czDTlZyBePShw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">快速求最小数</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">最小值的计算是<span style="color: black;">一样</span>的道理，依次按键盘</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">ALT M U I</span></span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b0902f20c04045b88007c961ae11faa8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=2KBFuTaZjt08RvAi4d5jR1kzyt8%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;"><span style="color: black;">这几个常用的函数<span style="color: black;">能够</span><span style="color: black;">运用</span>这个<span style="color: black;">办法</span>来快速计算，但<span style="color: black;">倘若</span>列表中<span style="color: black;">无</span>的函数该怎么实现呢？</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e5f00200ce1d4c3c955f96e33bdf24ca~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=OpkjksTgBDEX%2BOw9QQf%2BZwL6eYY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">统计数量</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">例如</span><span style="color: black;">咱们</span>想计算表中有多少人，统计一下姓名的数量，<span style="color: black;">那样</span>若<span style="color: black;">运用</span>「计数」的函数COUNT就出问题了。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8c9a5b5019f84a3d9d32b654c8ca9af5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=mEUD2hmiAE5IRhroRzO%2Bc7O8ysQ%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;"><span style="color: black;"><span style="color: black;">为何</span>计算结果是0呢？COUNT函数用于对数字单元格进行统计，而文本的统计则要用COUNTA函数。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/491824416b064c3b9811fca5eec38ef9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=cS2urSABw0JKZYtol3lKgT13GrM%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;"><span style="color: black;"><span style="color: black;">因此</span>，在按下ALT M U后，再敲一下“F”，在其他函数中<span style="color: black;">查询</span>这个功能。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/28bf68589d4048989b27e833049f68c7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=n0PgECOXpp921BvR3vrP3%2BF1Yt8%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;"><span style="color: black;">弹出「<span style="color: black;">插进</span>函数」窗口中搜索一下“COUNTA”，找到后双击函数名。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e91100194ae34f96b968e2f136c02d34~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=piBjrRUciJ93pP0U%2FZ1lkFLnPdw%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;"><span style="color: black;"><span style="color: black;">选取</span>B列中的姓名进行统计，<span style="color: black;">重视</span>不要<span style="color: black;">包括</span>标题，<span style="color: black;">由于</span>COUNTA是用于统计“非空”单元格，只<span style="color: black;">选取</span>需要统计数量的单元格就<span style="color: black;">能够</span>了。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/4c8a9b18e2c64c22a7e3c0685adfc186~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=UXxc2B%2FuzbYopfXk435L1eRQR2I%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;"><span style="color: black;">结果<span style="color: black;">表示</span>为4，这个<span style="color: black;">办法</span>略显<span style="color: black;">繁杂</span>，其实<span style="color: black;">能够</span>直接在B6单元格中输入</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">=COUNTA(B2:B5)</span></span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">这般</span>反倒更<span style="color: black;">方便</span>一点。</span></span></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">总结</h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a481d14aedd14e64aa4755694ba6c11b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981076&x-signature=aquWEjoQdhMAlQJIviPcovcde48%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;"><span style="color: black;">今天<span style="color: black;">咱们</span>学习了快速求和的<span style="color: black;">办法</span>「ALT=」，还借助菜单快捷键的<span style="color: black;">办法</span>实现了平均值、最大、最小以及计数的计算。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">以上<span style="color: black;">办法</span><span style="color: black;">能够</span>有效<span style="color: black;">加强</span>在Excel的操作效率和灵活性，相信<span style="color: black;">把握</span>了这些技巧，<span style="color: black;">针对</span>处理<span style="color: black;">海量</span>数据和进行财务分析等工作是非常有<span style="color: black;">帮忙</span>的。</span></span></p>
软文发布论坛开幕式圆满成功。 http://www.fok120.com
页:
[1]