Thanks guys now it's working

On Jan 29, 2:56 am, "MartinW" wrote:
Hi Dominick,

Another way to approach it is to put this in L2

=IF(L1="","",AVERAGE(A1:L1))
Then drag it across as far as is needed.

Now as you add data in M1,N1,O1 etc. your floating 12 week
average will appear in the cell beneath it.

HTH
Martin