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?
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,213,487
Messages
6,113,941
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top