近三个月平均分数 (9882)

R4{=IFERROR(SUM(TEXT(INDEX(4:4,N(IF({1},LARGE(IF(F4:Q4>0,COLUMN(F:Q)),{1,2,3}))))-75,"0;;0")/3)+75,"不及格")

另解{=IF(AND(RIGHT(LARGE(IF(F4:Q4>0,F4:Q4+COLUMN(A:L)/1%%),{1,2,3}),3)-75>=0),AVERAGE(RIGHT(LARGE(IF(F4:Q4>0,F4:Q4+COLUMN(A:L)/1%%),{1,2,3}),3)*1),"不及格")

另解{=IFERROR(SUM(TEXT(N(OFFSET(E4,,LARGE(IF(F4:Q4>0,COLUMN(A:L),0),{1,2,3})))-75,"0;;0")/3)+75,"不及格")