试问 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>有一套完整的图文<span style="color: black;">教育</span>，从最<span style="color: black;">基本</span>的概念<span style="color: black;">起始</span>，一步步由简入繁、从入门到精通，系统化地讲解 Excel 的各个知识点。</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> Excel 的操作技巧、快捷键大全、函数公式、数据透视表、图表、打印技巧等……学完全本，你<span style="color: black;">亦</span>能<span style="color: black;">作为</span> Excel <span style="color: black;">能手</span>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3.toutiaoimg.com/large/pgc-image/24ef7e0323e644b387c35536970b3ff4" style="width: 50%; margin-bottom: 20px;">
<div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">专栏</span></div>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">Excel从入门到精通</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">作者：Excel学习世界</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">99币</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">82人已购</div>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">查看</div>
</div>
</div>
</div>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">有网友求助：能否对一个有重复项的数据表基于某一列<span style="color: black;">同期</span>进行以下计算：</p>汇总某一列；对另一个有重复项的列不做计算（<span style="color: black;">例如</span>单价）；计算第三列的不重复个数<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>下图 1 中每种品类，计算出其对应的<span style="color: black;">独一</span>楼栋数、单价和总价，效果如下图 2 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/3b81abf0602e400aabf6824ffaf73abf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=gSkaZTJ4I0%2BYeZF83V15JhZs6o0%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/2c25f79d868f442482f25621050cc3d0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=8%2FYz8YHAu46sZJDQLKB%2BEPwFoVo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><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;">1. 选中数据表的任意单元格 --> <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-6w9my0ksvp/02836b3b7a3145c58140ced5c3f91dec~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=YProMBT3izj8zudOdd74FUS3Cp4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2. 在弹出的对话框中<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-6w9my0ksvp/3c1efbda6783484f95d3d476f6d1591a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=3jwKC%2BeDVt7%2BRUr2P1h68UwWDxw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3. 在右侧的“数据透视表字段”区域按以下方式拖动字段：</p>行：“品类”值：“楼栋”、“单价”、“总价”<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c673b74d4fd64ff69f9586f5cd91c3dd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=rMFlRJGz%2Bvo1QKXeP89kigSGOgo%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/e264b90207a448babc4435966fb2b96c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=dLChIzyfv4BESGOdTKVtNt6qjeY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4. 选中“楼栋”字段 --> 右键单击 --> 在弹出的菜单中<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-6w9my0ksvp/134485596ecf4cc39c924868871cadcf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=JB46AlHxoGCdd1AZyNL0mB0zKbM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">5. 在弹出的对话框的“计算类型”区域中<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-6w9my0ksvp/4ffd8c490b02452bae5592c8c0711ba0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=GVcVFkIdslSubcQaUqD%2FMB6SClo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">6. <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-6w9my0ksvp/56f4aac436ee4eaa9ef3f3f94be926ae~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=SwlQoNvGoYwh4Ya93Pg9bNZC0LQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">7. 在弹出的对话框的“计算类型”区域中<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-6w9my0ksvp/89ddae51f59444bc839378ac7442be9d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=vQrz19QDEI66o6xiD6GihY8WOGA%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/4cffbd68b223488488dc84743fc987f6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=jQx45n%2BB1gP%2Fke03UfK%2FKl%2BHS1E%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">8. 选中数据透视表的任意单元格 --> <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-6w9my0ksvp/fc120f48665c4cdebb41aca819ebcf70~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=k%2FIoGagDgVS8Lg%2B8SNvkjp6exsQ%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/aa8b874ef39548438abf6f91b0c14710~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=9jXyXvixj9i8xNA81k7zfAqH0wU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">9. 修改各个字段的标题名<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-6w9my0ksvp/40a9dedf1bb24c128f9f89304151598b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951863&x-signature=YrlNeEb3k2wnb6%2FvK%2B2XWkLfuJw%3D" style="width: 50%; margin-bottom: 20px;"></div>
你的言辞如同繁星闪烁，点亮了我心中的夜空。
页:
[1]