【单选题】
A =SUMIFS(D2:D301,A2:A301,"第一中学",B2:B301,"3 班")/COUNTIFS(A2:A301,"第一 中学",B2:B301,"3 班")
B =SUMIFS(D2:D301,B2:B301,"3 班")/COUNTIFS(B2:B301,"3 班")
C =AVERAGEIFS(D2:D301,A2:A301,"第一中学",B2:B301,"3 班")
D =AVERAGEIF(D2:D301,A2:A301,"第一中学",B2:B301,"3 班")
查看更多
