=SUMPRODUCT(N(总成绩!G1:G1137>=5000))
多条件计数
=COUNTIF(总成绩!G1:G3000,">537")
=COUNTIF(总成绩!C1:C3000,"=17班")
=COUNTIFS(总成绩!G1:G3000,">=537",总成绩!C1:C3000,"=17班")
=COUNTIFS(总成绩!K1:K3000,">=110",总成绩!C1:C3000,"=17班")
=COUNTIFS(总成绩!G1:G3000,">=537",总成绩!C1:C3000,"=17班",总成绩!K1:K3000,">=110",总成绩!C1:C3000,"=17班")
=COUNTIFS(总成绩!G1:G3000,">=537",总成绩!C1:C3000,"="&A7)
=CONCAT(RIGHT(A7,2),"班")
=COUNTIFS(总成绩!G1:G3000,">=537",总成绩!C1:C3000,"="&CONCAT(RIGHT(A7,2),"班"))
=COUNTIFS(总成绩!K1:K3000,">=110",总成绩!C1:C3000,"="&CONCAT(RIGHT(A7,2),"班"))
=COUNTIFS(总成绩!$G$1:$G$3000,">=537",总成绩!$L$1:$L$3000,">=110",总成绩!$C$1:$C$3000,"="&CONCAT(RIGHT(A7,2),"班"))