[已解决]再一次救助

cool_v2

5班课堂教学效率监控抽测结果（100分制）.rar (94.68 KB, 下载次数: 8)

2013-5-12 23:49 上传

点击文件名下载附件 低分率为：40分以下，不含40分  再除以总人数优良率为：80分以上，含80分    再除以总人数
合格率为：60分以上，含60分    再除以总人数

以下在平均分，优良率等设了函数，但此函数貌似不是很正确，忘能帮忙矫正
尤其是本班为84，特立本班的函数，数值还是没错的，但换了别的班82人，数值就不对了

最佳答案

月排行榜 / 总排行榜

as0810114

2013-5-13 00:01

优良率
=(COUNTIF(C6:C33,">=80")+COUNTIF(G6:G33,">=80")+COUNTIF(K6:K31,">=80"))/COUNT(C6:C33,G6:G33,K6:K31)
合格率
=(COUNTIF(C6:C33,">=60")+COUNTIF(G6:G33,">=60")+COUNTIF(K6:K31,">=60"))/COUNT(C6:C33,G6:G33,K6:K31)
低分率
=(COUNTIF(C6:C33,"<40")+COUNTIF(G6:G33,"<40")+COUNTIF(K6:K31,"<40"))/COUNT(C6:C33,G6:G33,K6:K31)

跳转到最佳答案楼层

as0810114

优良率
=(COUNTIF(C6:C33,">=80")+COUNTIF(G6:G33,">=80")+COUNTIF(K6:K31,">=80"))/COUNT(C6:C33,G6:G33,K6:K31)
合格率
=(COUNTIF(C6:C33,">=60")+COUNTIF(G6:G33,">=60")+COUNTIF(K6:K31,">=60"))/COUNT(C6:C33,G6:G33,K6:K31)
低分率
=(COUNTIF(C6:C33,"<40")+COUNTIF(G6:G33,"<40")+COUNTIF(K6:K31,"<40"))/COUNT(C6:C33,G6:G33,K6:K31)

cool_v2

OK，谢了，大哥，呵呵

xuyouxm

as0810114 发表于 2013-5-13 00:01
优良率
=(COUNTIF(C6:C33,">=80")+COUNTIF(G6:G33,">=80")+COUNTIF(K6:K31,">=80"))/COUNT(C6:C33,G6:G33, ...

老兄，这么晚了都不睡觉啊，敬业啊！

as0810114

xuyouxm 发表于 2013-5-13 09:21
老兄，这么晚了都不睡觉啊，敬业啊！

你步步紧逼，我压力山大啊。

xuyouxm

as0810114 发表于 2013-5-13 09:28
你步步紧逼，我压力山大啊。

我倒！，，，兄弟不要这样嘛！