Hello,
I am in desperate need of assistance. I am at wits end and not sure if what I need done is even possible. What I am ultimately trying to achieve is to administer weekly deductions over a 48-week period that yield a 52-week value. I am currently using a spreadsheet to calculate deduction totals over a 48-week period based on a number entered into cell i8. The problem I am having, is when I try to add the sum result of weeks 49 through 52 to the calculated table which, at this point of the process has to be divided by 48 weeks and then added to the first calculated result of the first 48 weeks. However, weeks 49 through 52 would have to be excluded because this total value would now have been spread across the 48-week period. The idea is to first calculate the total amount of deductions over the 52-week period based on the contents of the value of cell $i$8. Next, I need to add the sum of weeks 49-52 and divide the sum by the 48-week deduction period, and finally add those results to the 48 weeks. So far everything I have tried gives me an error.
The first calculating cell on the sheet is cell C11 containing the following =B11*$I$8 with the value of I8 being 4 so the immediate results of cell C11 shows 4. When I copy this formula down through the subsequent cells the results increase by 4 with C12 = to 8, C13 = to 12, and so on. What I would like the formula to do is use the result of I32 (which represents the total for week 48) and simulate the increment totals for the remaining weeks. If we use the example of 4 the sum total would be 808/48 yielding a result of 16.83 to be added to the 48-week totals with a new result in cell C11 now being 20.83. To make things more complex we have to remember that the current value of $I$8 being (4) for all intents and purposes is arbitrary, and could be any number or value when using this sheet to calculate totals. I am hopeful that someone here can help.Thanks in advance.
Bookmarks