Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Gaited/Rolling Percent to Goal

0

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  
Answer
Discuss

Discussion

Please include a sample file that shows what you are trying to do.
don (rep: 1989) Aug 2, '16 at 10:03 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login