Hi I am trying to work out a formula for Excel to work out a running average score under the "Assessments" table, column I for the listening, speaking, reading and writing columns.

The marks go from 0c to 8a (so 0c, 0b, 0a, 1c, 1b, 1a, 2c, 2b etc...)

I used to have it set up so that it would tell me an average for all 4 marks, but lost the formula and I was wondering if there is a way for it to work out an average even if not all 4 marks have been entered?

Any help would be greatly appreciated! Being a language teacher, spreadsheet formulae aren't my forte!Help.xlsx