I have 110 (so far) columns with sales, each column being one week. I
know I can do a HLOOKUP for a column based on the date at the top of
the column.

What I was wondering is if there's a way to get a 52 week average using
the final week as the lookup date? For example, if I do a hlookup (or
something similar?) for May 1, 2004 I could get the average of that
column and the 51 columns before it (back to week ending May 10, 2003).
The reason I want something like an hlookup is because the dates will be
changing, for one use I want the most recent week and 51 previous, for
other reports I want a certain special date (new compitition, new ad
program) and the 51 weeks leading up to it.

Thanks in advance,
Tom


--
tomandrobyn
------------------------------------------------------------------------
tomandrobyn's Profile: http://www.excelforum.com/member.php...o&userid=13879
View this thread: http://www.excelforum.com/showthread...hreadid=376076