Formular

[Justin]

Hello,

Can anyone help me with a formula:

I have a workbook with a stores weekly turnover.
At the bottom I want it to calculate it's average turnover.

At the moment I have the formula calculating the average
weekly turnover over 52 week, but what I need it to do is
calculate each week as I enter it.

EG: Week 1 $34543
Week 2 $35212
Average week = $34877
Week 3 $32123
Average week = $33959

This is a bit over my head.
Thanks if anyone can help.
Justin

..

 

[Frank Kabel]

Hi Justin
if you want to store these week values in B2:B53 just use
=AVERAGE(B2:B52)
blank cells are ignored by AVERAGE

 

[Guest]

Thanks for that,

That gives me an average over 52 weeks.
Is it able to works out the average to date not by 52
weeks.