今天跟大家分享一下excel数据分类汇总怎么做
![excel数据分类汇总怎么做](https://www.bmhysw.com/wp-content/themes/justnews/themer/assets/images/lazy.png)
1.如下图三个工作簿为某公司三个部门工资表现在我们想要快速统计出各个部门工资和。
![excel数据分类汇总怎么做](https://www.bmhysw.com/wp-content/themes/justnews/themer/assets/images/lazy.png)
2.首先我们点击下图选项
![excel数据分类汇总怎么做](https://www.bmhysw.com/wp-content/themes/justnews/themer/assets/images/lazy.png)
3.点击【汇总拆分】-【汇总大师】
![excel数据分类汇总怎么做](https://www.bmhysw.com/wp-content/themes/justnews/themer/assets/images/lazy.png)
4.选择【多簿汇总到一表】,然后点击【开始】
![excel数据分类汇总怎么做](https://www.bmhysw.com/wp-content/themes/justnews/themer/assets/images/lazy.png)
5.将要汇总处理的文件拖动到下图区域中,然后点击【下一步】
![excel数据分类汇总怎么做](https://www.bmhysw.com/wp-content/themes/justnews/themer/assets/images/lazy.png)
6.接着我们设置【汇总区域】和【关键词】然后点击【提取全部字段】
![excel数据分类汇总怎么做](https://www.bmhysw.com/wp-content/themes/justnews/themer/assets/images/lazy.png)
7.接着我们分别设置【汇总字段】和【依据字段】然后点击【下一步】
![excel数据分类汇总怎么做](https://www.bmhysw.com/wp-content/themes/justnews/themer/assets/images/lazy.png)
8.最后点击【开始】即可
![excel数据分类汇总怎么做](https://www.bmhysw.com/wp-content/themes/justnews/themer/assets/images/lazy.png)
9.完成效果如下图
![excel数据分类汇总怎么做](https://www.bmhysw.com/wp-content/themes/justnews/themer/assets/images/lazy.png)
声明:所有白马号原创内容,未经允许禁止任何网站及个人转载、采集等一切非法引用。本站已启用原创保护,有法律保护作用,否则白马号保留一切追究的权利。发布者:白马号,转转请注明出处:https://www.bmhysw.com/article/8418.html