excel前80%平均分
=AVERAGE(IF(C250:C357>=PERCENTILE(C250:C357,20%),C250:C357))
=SUMPRODUCT(((袁庄小学)>=LARGE((袁庄小学),ROUND(0.8*COUNT((袁庄小学)),0)))*(袁庄小学))/ROUND(0.8*COUNT((袁庄小学)),0)
=AVERAGE(IF((大沟桥小学>=LARGE(大沟桥小学,15)),大沟桥小学))
=AVERAGE(IF(C250:C357>=PERCENTILE(C250:C357,20%),C250:C357))
=SUMPRODUCT(((袁庄小学)>=LARGE((袁庄小学),ROUND(0.8*COUNT((袁庄小学)),0)))*(袁庄小学))/ROUND(0.8*COUNT((袁庄小学)),0)
=AVERAGE(IF((大沟桥小学>=LARGE(大沟桥小学,15)),大沟桥小学))
