Hi,

I have attached a screen shot of some weekly budgets systems i am trying to put together, i have created a test spreadsheet with no formulas as i cannot work out an efficient formula for what i require.

As you will note from the screen shot i require a formula for columns 6 and 7.
Column 6 will just show the difference between column 4 and 5 with column 4 always being constant and 5 changing from week to week.

Column 7 i would like to show the cumulative difference that is overall from start of week 1 to end (week 52) as shown in screen shot the formula must add each week then targets then deduct actual s and put in a plus or minus format.

budgetformula.png

Any help would be greatly appreciated.

regards,