Formula for average with column heading and column subheading

Hopefully this will make sense and be easy enough for someone more learned (and less hungover) than I.   I have a table which has test scores. At the top of each column in row 1 is the name of the ...