Calculation of a running mean

[Guest]

I use a spreadsheet to record test scores. There are 12 tests to be taken
over the year and I would like to calculate a running mean of the scores as
they are inputted. I have tried just calculating a mean but the spreadsheet
does not appear to be able to cope with calculating a mean from a formula
which refers to empty cells (those cells referring to the tests which have
yet to be taken).I am using Excel 2003 and I don't have the statistics
package available.

How do I calculate a running mean?

 

[Guest]

If data is in cells A1:A12, then =AVERAGE(A1:A12) will calculate average if
future test scores are left blank. Adding new data will update average.

 

[Guest]

Excellent. Thank you.

If data is in cells A1:A12, then =AVERAGE(A1:A12) will calculate average if
future test scores are left blank. Adding new data will update average.