如何计算20-50岁的人数?
成都office培训解答：
=COUNTIF(C3:C17,”>=20″)-COUNTIF(C3:C17,”>50″)
=SUMPRODUCT((C3:C17>=20)*(C3:C17<=50))
=FREQUENCY(C3:C17,50)-FREQUENCY(C3:C17,19)
｛=SUM(COUNTIF(C3:C17,”>=”&{20,51})*{1,-1})｝
如何计算男20-50岁的人数?
=SUMPRODUCT((B3:B17=”男“)*(C3:C17>=20)*(C3:C17<=50))
求各分数段人数
90—100 =COUNTIF(B2:B43,”>=90″)
80—89 =COUNTIF(B2:B43,”>=80″)-COUNTIF(B2:B43,”>=90″)
70—79 =COUNTIF(B2:B43,”>=70″)-COUNTIF(B2:B43,”>=80″)
60—69 =COUNTIF(B2:B43,”>=60″)-COUNTIF(B2:B43,”>=70″)
50—59 =COUNTIF(B2:B43,”>=50″)-COUNTIF(B2:B43,”>=60″)