请教有关人数统计，谢谢

i119110

<p>大家好，我们公司有600多人，每月的进出都很大，核对每个部门的人数是一个很头痛的事情，请问大家有没有什么好的表格可以解决这个问题？</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 另外，我这边想按照部门来统计人数，请问有什么好的公式来统计呢？我就不用每次都用手工去数了。</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 表格举例如下：</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p><p><table cellspacing="0" cellpadding="0" width="137" border="0" style="WIDTH: 103pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="62" style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 1984;"></col><col width="75" style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2400;"></col></colgroup><tbody><tr height="88" style="HEIGHT: 66pt; mso-height-source: userset;"><td class="xl27" width="62" height="88" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 47pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 66pt; BACKGROUND-COLOR: transparent;"><strong><font face="宋体">姓名</font></strong></td><td class="xl26" width="75" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><strong><font face="宋体">部门</font></strong></td></tr><tr height="24" style="HEIGHT: 18pt; mso-height-source: userset;"><td class="xl24" height="24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent;"><font face="宋体">袁宋军</font></td><td class="xl25" width="75" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">保安部</font></td></tr><tr height="24" style="HEIGHT: 18pt; mso-height-source: userset;"><td class="xl24" height="24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent;"><font face="宋体">李静</font></td><td class="xl25" width="75" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">财务部</font></td></tr><tr height="24" style="HEIGHT: 18pt; mso-height-source: userset;"><td class="xl24" height="24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent;"><font face="宋体">刘辉</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">财务部</font></td></tr><tr height="24" style="HEIGHT: 18pt; mso-height-source: userset;"><td class="xl24" height="24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent;"><font face="宋体">谢卫平</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">财务部</font></td></tr><tr height="24" style="HEIGHT: 18pt; mso-height-source: userset;"><td class="xl24" height="24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent;"><font face="宋体">宣淑湘</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">客房部</font></td></tr><tr height="24" style="HEIGHT: 18pt; mso-height-source: userset;"><td class="xl24" height="24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent;"><font face="宋体">胡和平</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">餐饮部</font></td></tr><tr height="24" style="HEIGHT: 18pt; mso-height-source: userset;"><td class="xl24" height="24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: transparent;"><font face="宋体">戴丁玉</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">客房部</font></td></tr></tbody></table></p><p></p><p>&nbsp; </p>

Gemmy

用数据透视表就可以了。

1004820701

<p>如果部门有Ｂ列,COUNTIF(B:B,"财务部")</p><p></p>

hyc2222

<p>我们公司还多些,2000人左右,每月也是进去100左右.</p><p>统计总人数很简单.我在姓名前加了一列"序号",值等函数ROW()-1,明白没?看最后一个数字是几就知道有多少人,</p><p>按部门统计用筛选就行了.</p>

i119110

请问数据透视表要如何应用在这里呢？好像统计不了人数吧

Gemmy

<p>用透视表来统计，如附件。数据源选择的是A:B列，这样即使增加数据，只要刷新透视表即可更新。</p> 36GGQsZG.rar (5.64 KB, 下载次数: 38)

2007-4-13 17:14 上传

点击文件名下载附件
请教有关人数统计，谢谢

<br/>

不争

<p>用分类汇总不就行了</p>