如何用公式和函数计算各班前40名学生的各科平均成绩

长公式=SUMPRODUCT(((Sheet2!$C$2:$C$1206=$A2)*Sheet2!$D$2:$D$1206>=LARGE((Sheet2!$C$2:$C$1206=$A2)*Sheet2!$D$2:$D$1206,40))*(Sheet2!$C$2:$C$1206=$A2)*Sheet2!E$2:E$1206)/SUMPRODUCT(((Sheet2!$C$2:$C$1206=$A2)*Sheet2!$D$2:$D$1206>=LARGE((Sheet2!$C$2:$C