Hi!

So, what do you want to do?

Average the last 53 entries in column B?

What if there aren't 53 entries?

Biff

"SPenney" wrote in
message ...

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.


--
SPenney
------------------------------------------------------------------------
SPenney's Profile:
http://www.excelforum.com/member.php...fo&userid=1079
View this thread: http://www.excelforum.com/showthread...hreadid=510252