假如A2:A10为性别一列,使用COUNTIF函数.=countif(A2:A10,"女")=countif(A2:A10,"男")
假定性别在B列=countif(b:b,"女")=countif(b:b,"男")
