need help with a formula - variation of sum

I have a table of data (test scores) for students at the top is the maximum score they could have achieved for each test.  On the left side I have average all their test scores to give a grade. (see ...