excel表格中怎么统计男女

1.excel2007统计男女生人数

自定义一个函数吧。同时按Alt和F11进入宏界面，点菜单的插入，模块，粘贴如下代码：

Function CountVisible(xRng As Range, xStr As String) As Integer

Dim cell As Range

For Each cell In xRng

If cell.Rows.Hidden = False And cell = xStr Then CountVisible = CountVisible + 1

Next

End Function

回到Excell，在B11输入 =countvisible(C2:C9，"男") 或者 =countvisible(C$2:C$9,left(A11)），后者可以向下复制。