Top, Middle and Bottom Third Averages

JGDANIEL I suggest you introduce some helper formulae below your statistics. It makes maintaining and expanding the schedule relatively easy and you avoid long and confusing formulae. If you want to add a pupil, first insert a row above thet stats. Then just start typing directly below the last pupil. The table will expand automatically and the so will the calculations in the cells below. Adding a subject works similar. Just start typing directly outside the table on the right hand side and the table will automatically extend. Then, drag the stats and the helper formulae below to the next column and all should update instantly.

Now, the helper formulae that I am referencing in the stats are dynamic array formulae. If you are on an older Excel version that does not recognise these, you can use the formulae from columns E,F and G.