I have a master sheet and three more sheet (opening stock,receipts &
closing stock) and within these 3 sheets there is product code ,
description price and the week numbers(i.e from wk 12 to wk 52) which
have quantities. I want to put a function in master sheet that will
calculate the sales rolling average based on week number eg
If i take 1 week average if i am in wk 15 it should give me cellvalue
of wk 14, and in 13 it gives me week 12 value.
If its 2 weeks average if iam in week 15 it should give an average of
week 14and 13, if am in week 14 it should give me the average for week
13 and 12.
If its 3 weeks and am in week 17, it should give me the average for
week 14,15,16 while in week 15 it should give me average for week
12,13,and 14

Can sb assist???


--
William Okumu
------------------------------------------------------------------------
William Okumu's Profile: http://www.excelforum.com/member.php...o&userid=33745
View this thread: http://www.excelforum.com/showthread...hreadid=535206