工作中必须的9个Excel统计类函数，统计数据更快速方便！
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在<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>介绍八个常用的Excel统计类函数，正确<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 style="color: black;">困难</span>，从此统计数据更<span style="color: black;">方便</span>。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">1、</span>SUMIFS函数，用于多<span style="color: black;">要求</span>求和。</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、打开数据源，<span style="color: black;">咱们</span>统计评级为A的晚班生产量之和，<span style="color: black;">咱们</span>输入公式=SUMIFS(D2:D7,E2:E7,"A",C2:C7,"晚班")，按回车键得到结果，如图。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/bc853f71bc604f13b6f10bd3706e59ec~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981061&x-signature=NzxYVPiDD4rUuJ%2FdUt7QtGF%2FJWQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">2、</span>COUNT函数，计数函数，用于返回<span style="color: black;">包括</span>数字以及<span style="color: black;">包括</span>参数列表中的数字的单元格的个数。利用函数的这一特性，<span style="color: black;">咱们</span><span style="color: black;">能够</span>自动生成序号并随时会跟着数据变化而更新。</h1>打开数据源，<span style="color: black;">咱们</span>在单元格中输入公式：=COUNT(A$1:A1)+1，函数参数里面前面的参数A1必须用$固定，往下拖动从而实现数据区域自动变化。<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/4b19fb7763a24fd3a43db61bc3615015~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981061&x-signature=4x9LoMz1njf%2FnQ0rVhkAh2hBcGQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">3、</span>COUNTA函数，计算非空单元格的个数。</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3、打开数据源，<span style="color: black;">咱们</span>需要统计生产量不是0的个数，在单元格中输入公式：=COUNTA(C2:C7)，单元格内为空会被忽略。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2fdfee40094f4cd0bf4385e463b3671d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981061&x-signature=cw29O4OT9cdt4z%2ByL5Fcfoh96y4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">4、</span>COUNTIF函数，计算区域中满足给定<span style="color: black;">要求</span>的单元格的个数。</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4、打开数据源，<span style="color: black;">咱们</span>需要统计生产量大于3000的数量，在单元格中输入公式：=COUNTIF(D2:D7,">3000")，回车键得到结果。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7f7c53fa51fc47eda2f076cb26ed93d6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981061&x-signature=2rvReNYHVHnQQbft%2Bmw7emvCUH0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">5、</span>COUNTIFS函数，多<span style="color: black;">要求</span>计数函数。</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">5、打开数据源，统计1车间评级为A的员工人数。<span style="color: black;">运用</span>公式=COUNTIFS(B2:B7,"1车间",E2:E7,"A")。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/896f89e156364534adc162bf83dea105~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981061&x-signature=6bLaFfxeegJ9bWsIkSafYYhnLV4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">6、</span>MAXIFS函数，按<span style="color: black;">要求</span>求最大值。</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">6、打开数据源，统计评级为A的晚班最大值，<span style="color: black;">咱们</span>输入公式=MAXIFS(D2:D7,E2:E7,"A",C2:C7,"晚班")。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a6e66c8da6054606878189059f061b5d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981061&x-signature=iJSAGIx1vsM2LbhCmnjGAGjZeJ8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">7、</span>MINIFS函数，按<span style="color: black;">要求</span>求最小值。</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">7.打开数据源，<span style="color: black;">咱们</span>需要统计评级为A的晚班最小值，在单元格中输入公式=MINIFS(D2:D7,E2:E7,"A",C2:C7,"晚班")。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/652f845269f44716b6f90dacff1fcb2b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981061&x-signature=RP99tysE9fXBdm1zJ2jxLfPtEYs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">8、</span>FREQUENCY函数，进行分段统计。</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">8、打开数据源，<span style="color: black;">咱们</span>统计生产量大于1500，<span style="color: black;">少于</span>3500的个数。在单元格中输入公式=FREQUENCY(D2:D7,{3500,1500})。前面为最大值，后面输入最小值。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b00a81fadd264ff19d8b936c8e2b9661~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981061&x-signature=gY3OmMeASSskvL2IdR6k6H9N6J4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">九、AVERAGEIFS函数，<span style="color: black;">按照</span>多个<span style="color: black;">要求</span>求平均值。</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">9、打开数据源，统计评级为A的晚班平均生产量，输入公式=AVERAGEIFS(D2:D7,E2:E7,"A",C2:C7,"晚班")。如图。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/ecdadf92c49740b9bbefbd8080b6166e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981061&x-signature=tUxN25ojaWRweno1D9ZuB2hfOh8%3D" style="width: 50%; margin-bottom: 20px;"></div>
页:
[1]