Rolling Averages

[JoeCars]

I would like to create a summary page with the 3 month rolling average of
sales.
I have all the sales, profit and salesperson data compiled on 1 worksheet.
I would like to use a drop down menu on the summary (already set it up by
months) to choose a month of the year and then have the average of the
previous 3 months data displayed.
Is this possible? and if yes, How?

 

[Peo Sjoblom]

Yes it is possible, depending on the data sheet layout the answers would be
different.
Is the sales table done using real excel dates with sales per day like


09/10/08 4,500
10/10/08 12,800


etc?



--


Regards,


Peo Sjoblom