Rolling Averages
 

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?

Rolling Averages
 

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



"JoeCars" wrote in message
...
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?