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班")
A.商场:恒大影城、花生唐购物中心、南城百货、枫林美食广场、联达广场、万象城、新城吾悦广场
B.学校:恒大城国际双语幼儿园、临桂三小、临桂一中、临桂中学
C.医疗:桂林医学院第二附属医院、中西医结合医院、桂林旅游综合医院