Calculating Moving Average

sidneyvanness

New Member
Joined
Oct 13, 2008
Messages
7
We are developing a tiered commission structure for our sales reps whereby the percent commission they earn will be based on the recent moving average of their sales. For example, if salesperson X has a 60 day moving average of $25,000 in sales, they would earn a higher percentage of commissions on all subsequent sales than the person who has a 60 day moving average of only $5000 in sales.

I would like to develop a workbook that can calculate a moving average based on

1. An input variable that specified the number of days over which the moving average should be calculated.
2. An array of dates in one column and
3. A corresponding array of dollar amounts in another.

I’ve not been able to find a clear example of how to do this in Excel…any advice on which functions I should be thinking of?
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,100,209
Messages
5,473,165
Members
406,849
Latest member
gustavor0

This Week's Hot Topics

Top