Excel表格怎么统计数量？学会这3种办法就够了
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">所属课程：《Excel函数公式大全》</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第4章：451个Excel函数</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第141节：Excel表格怎么统计数量</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel表格怎么统计数量？连这都不会，难怪同事都叫你小白！<span style="color: black;">博主</span>整理了：三种表格统计数量的<span style="color: black;">办法</span>，赶紧来学习吧！</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/bfc6d06db93e4da8830d92a0ae75aa82~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727966108&x-signature=t%2Fd5K8BYwookgWvZIfXr8%2FYf74A%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel表格怎么统计数量</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1、状态栏预览：</strong></p>
<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>状态栏预览了！用鼠标选中：B列单元格区域，在最下面的【状态栏】，就会自动为<span style="color: black;">咱们</span>统计数量：7个！</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/ca23073015c3465f8d9ac101c679a126~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727966108&x-signature=gEP7QUdJOs3G4rC1G0StZ4%2BTEVo%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel表格怎么统计数量</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span>用鼠标选中：C列，<span style="color: black;">由于</span>【大乔】和【小乔】，<span style="color: black;">无</span>输入【年龄】，<span style="color: black;">因此</span>统计数量是：5个！</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/6bcb3eeb8cb64f5c8ddfc437ddbfc2f8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727966108&x-signature=IMg3Jy4LZV41LuxUagwcWPyZwVY%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel表格怎么统计数量</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2、通用计数：Count函数</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">第1</span>种<span style="color: black;">办法</span>效率太低！<span style="color: black;">意见</span><span style="color: black;">大众</span><span style="color: black;">运用</span>：Count函数统计数量；<span style="color: black;">不消</span>看状态栏，仅需一键搞定！</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">首要</span>单击：G2单元格，在编辑栏，输入Count函数：=COUNT（），<span style="color: black;">而后</span>用鼠标选中：C列，按回车键结束，<span style="color: black;">就可</span>统计出数量：6个；<span style="color: black;">倘若</span>想统计【月薪】列，只需要把函数参数，修改成：C:C就行了！</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/0a75b2301a764343aeb30ba974e2476c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727966108&x-signature=wB9nl1ZN86%2BJH3CFszmi75Prp3M%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel表格怎么统计数量</p>
</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;">由于</span><span style="color: black;">咱们</span>统计的是：数值的数量，<span style="color: black;">因此</span><span style="color: black;">第1</span>行并不计数！<span style="color: black;">倘若</span>想计算：所有文本的个数，<span style="color: black;">能够</span><span style="color: black;">运用</span>：CountA函数！</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">实质</span>工作中，更常用的是：Countif函数！<span style="color: black;">能够</span>一键计算出：【魏国】员工的个数</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3、<span style="color: black;">要求</span>计数：Countif函数</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/96e6bf8abfa34b3ca5d5c55d7a453761~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727966108&x-signature=7ld8j9ui3MVLmee%2BHWpK%2Fq6yhPs%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel表格怎么统计数量</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">双击G2单元格，输入Countif函数：<strong style="color: blue;"><span style="color: black;">=COUNTIF(A:A,F2)</span></strong>；按回车结束，<span style="color: black;">就可</span>一键统计出：【魏国】所有员工个数！</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/2f2527e4791248cbb65069c792743d82~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727966108&x-signature=ZFyA58ASIdR3vufmzFveOds4GVY%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel表格怎么统计数量</p>
</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;">【Countif函数】第1参数：A:A，<span style="color: black;">表率</span>计数区域；第2参数：F2，<span style="color: black;">表率</span>计数<span style="color: black;">要求</span>，<span style="color: black;">亦</span><span style="color: black;">便是</span>魏国的员工！</span></strong></p>
<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>工作效率，<span style="color: black;">得到</span>老板的<span style="color: black;">喜爱</span>！<span style="color: black;">剧烈</span><span style="color: black;">举荐</span>你学习我的专栏：《Excel函数公式大全》，课程共156节，<span style="color: black;">包括</span>：451个excel函数，185个快捷键，几百个表格制作入门教程，<span style="color: black;">每一个</span>知识点都有案例详解！</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">除此之外！还免费送你《配套随堂表格素材》，详解13类451个函数用法！课后免费答疑，<span style="color: black;">帮忙</span>你在最<span style="color: black;">短期</span>内，学会Excel正确用法，让你的工作效率飙升，秒变Excel大神！</p>
感谢楼主分享，祝愿外链论坛越办越好！ 你的言辞如同繁星闪烁，点亮了我心中的夜空。
页:
[1]