A.=AVERAGEIFS(D2:D301,A2:A301,"第一中学”,B2:B301,"3班")
B.=SUMIFS(D2:D301,A2:A301,"第一中学”,B2:B301,"3班")/CUNTIFS(A2:A301,"第一中学”,B2:B301,"3班")
C.=SUMIFS(D2:D301,B2:B301,"3班")/CUNTIFS(B2:B301,"3班")
D.=AVERAGEIF(D2:D301,A2:A301,"第一中学”,B2:B301,"3班")
Copyright © 2020 www.daanwo.com All Rights Reserved |