如何在电子表格中统计双及人数、双优人数、双及率和双优率等?

Question

如何在电子表格中统计双及人数、双优人数、双及率和双优率等?

Answer 1

假设C列和D列为两科成绩,从第2行开始.假设到15行成绩结束,根据你的实际情况调整下面公式中的行号.
统计双及人数：
=COUNTIFS(C2:C15,">=60",D2:D15,">=60")
统计双优人数：
=COUNTIFS(C2:C15,">=90",D2:D15,">=90")
双及率：
=COUNTIFS(C2:C15,">=60",D2:D15,">=60") / COUNT(C2:C15)
双优率：
=COUNTIFS(C2:C15,">=90",D2:D15,">=90") / COUNT(C2:C15)