张三所任教班级的平均值在G2输入公式如下,下拉=SUMIF($B$2:$B$20,F2,$C$2:$C$20)/COUNTIF($B$2:$B$20,F2)
公式下拉g2=sumproduct((b$2:b$11=f$2)*(c$2:c$11))/sumproduct((b$2:b$11=f$2)*1)