help with a running average formula

Hi i was wondering if anyone can help. I've got a spreadsheet which records attendance figures for each week. I've got all the totals and a weekly average but i want to include a running weeklt total average. Any help with this would be greatly appreciated as the way i've done it is very long winded and excel comes up with an error at week 33 as there is to many references for the formula to work.