[求助]统计工种问题！！

yuzhijuan

如何统计出共有多少个单位！单位下有多少个工种！每工种多少人！请教有何方法！谢谢！刚才忘记传附件了！呵呵<br/>

yuzhijuan

<p>我传不上附件!问题就写在这里吧！</p><p><table cellspacing="0" cellpadding="0" width="248" border="0" style="WIDTH: 186pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="104" style="WIDTH: 78pt; mso-width-source: userset; mso-width-alt: 3328;"></col><col span="2" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td width="104" height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; WIDTH: 78pt; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">单位</td><td width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">姓名</td><td width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">工种</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">技术部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">中都和</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">钳工</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">技术部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">山东</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">美工</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">技术部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">反对反</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">司机</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">技术部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">广告费</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">钳工</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">技术部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">发热体</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">司机</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">技术部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">二位二</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">美工</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">技术部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">让对方的</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">美工</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">技术部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">沃尔沃</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">美工</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">技术部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">丰富的</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">美工</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">技术部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">通过</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">美工</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">财务部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">罚担罚</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">轻功</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">财务部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">首都师大</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">会计</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">财务部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">杀毒</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">轻功</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">财务部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">首都师大</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">司机</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">人力资源部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">萨达</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">钳工</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">人力资源部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">罚担罚</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">司机</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">人力资源部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">而饿</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">小车司机</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">人力资源部</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">大幅度</td><td style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: #f4f4f4; BORDER-LEFT: #f4f4f4; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: transparent;">大车司机</td></tr></tbody></table></p>

jssy

附件需要压缩后才能上传。

sunya_0529

用数据透视表吧，没有附件，也帮不上忙，这个论坛里有好多有关的教程，比较通俗易懂，适合初学者入门。

hjhotel

用excel2007的多条件统计函数，countifs(),可方便解决。

xolf

数据－－分类汇总