I need a formula for a gaited or rolling percent to goal. Each week the sale people need to sell a certain avergae number of units to hit their quarterly unit goal. I want to enter the number of units sold into a new column each week and have a column whch shows where the percent to goal for that period of time. For example, if they need to sell 20 units a week and in week 1 they sell 20, then the gaited column should show 100%. The next week if they sold only 10 units, I want to enter 10 in the column for that week and have the gaited column show 75%.
Q3 JUL Q3 AUG Q3 SEPT 8-Jul 15-Jul 22-Jul 29-Jul 5-Aug 12-Aug 19-Aug 26-Aug 2-Sep 9-Sep 16-Sep 23-Sep 30-Sep Q3 Actuals Q3 Goal Total Q3 Units Needed Gaited % to Goal 19 19 10 25 0 0 0 0 0 0 0 0 0 73 250 177