数学都及格的平均成绩:
=AVERAGEIF(C2:C9,">=60")
语数英都及格的人的数学平均成绩:
=AVERAGEIFS(C2:C9,B2:B9,">=60",C2:C9,">=60",D2:D9,">=60")
09-10 315阅读
08-09 220阅读
04-27 151阅读
05-08 133阅读
03-30 75阅读
11-13 146阅读
11-03 162阅读
10-27 497阅读
07-28 122阅读
07-21 302阅读