关于电子表格Excel的问题
如何统计80至90分之间的人数?
假设分数数据在C2:C50单元格区域内: 公式为 =COUNTIF(C2:C50,">=80")-COUNTIF(C2:C50,">=90")
用函数式:=countif($a$2:$a$60,>=80)-countif($a$2:$a$60,>90)即可
答:总人数: =COUNTA(A3:A58) 男生: =COUNTIF(B3:B58,"男") 女生: =COUNTIF(B3:B58,"女") 内宿生: =COU...详情>>
答:详情>>