=AVERAGEIF(C2:C9，" & gt=60")

Average math scores of people who have passed both English and Chinese;

=AVERAGEIFS(C2:C9，B2:B9，" & gt=60 "，C2:C9，" & gt=60 "，D2:D9，" & gt=60")