Rolling Average

S

SPenney

I have a sheet that needs to calculate a 53 week rolling average.
Column A has the week number; Column B has the data to be averaged.

I'm familiar with the offset function when charting and wonder if this
can be replicated for calculating an average to match my chart.
 
B

Biff

Hi!

So, what do you want to do?

Average the last 53 entries in column B?

What if there aren't 53 entries?

Biff
 
D

Domenic

Assuming that Column B, starting at B2, contains your data, try...

=AVERAGE(OFFSET(B2,MATCH(9.99999999999999E+307,B2:B65536)-53,0,53))

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top