Excel公式求及格率

Question

Excel公式怎样求不同列中部分数据的及格率？例如，我要求下面C3到C7以及F3到F6这九个数据中高于60的数据占这些数据的百分比，怎么写公式？我输入的公式是 =COUNTIF(C3：C7，F3：F6，">60")/(C3：C7，F3：F6)，可是提示错误。

Answer 1

不能这么写，你要么给E:G列移到A:C列去统一写
要么=(countif(c3:c7,">60")+countif(g3:g6,">60"))/(count(c3:c7)+count(g3:g6))

Answer 2

应该是：=（COUNTIF(C3：C7，">60")+COUNTIF(F3：F6，">60")）/COUNT(C3：C7，F3：F6)

Answer 3

改成=COUNTIF(C3：C7，F3：F6，">=60")/COUNTA(C3：C7，F3：F6)

Answer 4

=(COUNTIF(C3:C7,">=60")+COUNTIF(G3:G6,">=60"))/COUNTA(C3:C7,G3:G6)

Answer 5

=(countif(c3:c7,">=60")+countif(g3:g6,">=60"))/counta(c3:c7,g3:g6)