平均 二班 合併計算 (10415)

H2:J2=SUM(SUMIF($B:$B,{84,85},D:D))/SUM(COUNTIF($B:$B,{84,85}))

另解{=AVERAGEA(IF(($B$2:$B$16={84,85}),D$2:D$16))