如何在 Excel 中使用自动筛选进行小计？
我目前正在制作一份 Excel 表格，其中包含公司工作人员的列表。 该公司有多个团队和多个职位，我已将它们全部列在 Excel 工作表中（我使用的是 Excel 2007）。由于职位和人员列表可能每天都会有所不同（根据谁升职或解雇），我必须制作日期列并在“日期”、“职位”和“团队”上放置过滤器。
现在我想要过滤掉它，比如说，年份 = 2011 年，职位 = 团队经理，团队 = 信息技术。团队。 我已经设法自己走到这一步，但现在我想知道当我根据职位或团队名称过滤掉这个（从 700 多行中）时，是否可以添加同一团队下的总人数或相同的职位。
例如，如果信息技术部门有 10 人。团队，我可以使它显示“总人数 = 10”，而不必在应用过滤器时手动计算每个人吗？ 另外，如果信息技术部门有 4 个人。团队作为经理，则显示“IT团队下的经理总数= 4”。
我可以在 Excel 中使用任何命令或方法来执行此操作吗？
I am currently working on an Excel sheet of list of people working in a company.
The company has multiple teams and multiple positions and I've listed them all in an Excel sheet (I am using Excel 2007). And because the positions and the list of people may differ on daily basis (based on who gets promoted or fired) I had to make date column and place a filter on the "date", "position", and "team".
Now I want to make it so that I filter it out for, let's say, year = 2011, position = team manager, team = information tech. team.
I have managed to get this far on my own but now I am wondering when I filter this out (out of 700+ lines), based on the position or team name, if I can add the total number of people under the same team or same positions.
For example, if there are 10 people under information tech. team, can I make it so it displays "total number of people = 10", without me having to count each one of them by hand when I apply the filter?
Also, if there are 4 people under information tech. team as the manager, it would show that "total number of managers under IT team = 4".
Are there any commands or methods I can use in Excel to do this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
在您想要的单元格中输入以下内容，它将根据此链接进行更改：
Enter the following in the cell you want it in, and it will change, as per this link: