用COUNTIFS函数求60到80分之间的成绩个数
=COUNTIFS(B2:B10,">60",B2:B10,"<=80")
用COUNTIF函数求60到80分之间的成绩个数
=COUNTIF(B2:B10,">60")-COUNTIF(B2:B10,">80")
用FREQUENCY函数统计多个区间的数据个数
{=FREQUENCY(B2:B10,E2:E5)}
更多推荐
excel函数FREQUENCY、COUNTIFS、COUNTIF
=COUNTIFS(B2:B10,">60",B2:B10,"<=80")
=COUNTIF(B2:B10,">60")-COUNTIF(B2:B10,">80")
{=FREQUENCY(B2:B10,E2:E5)}
更多推荐
excel函数FREQUENCY、COUNTIFS、COUNTIF
发布评论