Hi i need some help and hope that it is possible to do, bare with me and i'll try and explain the best i can
the answer will go in the difference column (P)
as figures are entered into each month and category i want it to work out the total planned amounts times the amount of months that have figures in them minus the total of the months
so for what i have here so far P3=(Q3*2)-(-300+250)
which of course would work, but without having to change the formula each time i want it to work itself out
i hope this makes sense on what i need to do, thanks in advance for your help
TOTALS
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 266px;"><col style="width: 21px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 106px;"><col style="width: 138px;"><col style="width: 128px;"></colgroup><tbody>
</tbody>
the answer will go in the difference column (P)
as figures are entered into each month and category i want it to work out the total planned amounts times the amount of months that have figures in them minus the total of the months
so for what i have here so far P3=(Q3*2)-(-300+250)
which of course would work, but without having to change the formula each time i want it to work itself out
i hope this makes sense on what i need to do, thanks in advance for your help
TOTALS
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
1 | 2012 SUMMARY/TOTALS | |||||||||||||||||
2 | Category | Initial Balance | JAN | FEB | MAR | APR | MAY | JUNE | JULY | AUG | SEPT | OCT | NOV | DEC | YTD | Difference | Planned Amounts/Month | Planned Amounts/Year |
3 | Work Expenses | $ - | $ - | $ - | $ - | $ 300.00 | $ 250.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 550.00 | $ 250.00 | $ 3,000.00 | ||
4 | General Groceries | $ - | $ - | $ - | $ - | $ 1,200.00 | $ 1,500.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 2,700.00 | $ 1,250.00 | $ 15,000.00 | ||
5 | Take Away | $ - | $ - | $ - | $ - | $ 150.00 | $ 200.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 350.00 | $ 166.67 | $ 2,000.00 | ||
6 | Kids Activites | $ - | $ - | $ - | $ - | $ 400.00 | $ 300.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 700.00 | $ 333.33 | $ 4,000.00 | ||
7 | Petrol | $ - | $ - | $ - | $ - | $ 550.00 | $ 600.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 1,150.00 | $ 583.33 | $ 7,000.00 | ||
8 | Rent | $ - | $ - | $ - | $ - | $ 1,600.00 | $ 1,600.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 3,200.00 | $ 1,666.67 | $ 20,000.00 | ||
9 | School Expenses(Books, Fees etc.) | $ - | $ - | $ - | $ - | $ 50.00 | $ 100.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 150.00 | $ 83.33 | $ 1,000.00 | ||
10 | Debt Payments(Credit Card, Loans etc.) | $ - | $ - | $ - | $ - | $ 150.00 | $ 200.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 350.00 | $ 250.00 | $ 3,000.00 | ||
11 | Regular Bills(Phone, Utilities, Insurance etc.) | $ - | $ - | $ - | $ - | $ 400.00 | $ 700.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 1,100.00 | $ 583.33 | $ 7,000.00 | ||
12 | Miscellaneous | $ - | $ - | $ - | $ - | $ 200.00 | $ 100.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 300.00 | $ 166.67 | $ 2,000.00 | ||
13 | Gifts(Birthdays, Christmas etc.) | $ - | $ - | $ - | $ - | $ 300.00 | $ 250.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 550.00 | $ 250.00 | $ 3,000.00 | ||
14 | Health Expenses(Prescriptions, Dentist, Doctor etc.) | $ - | $ - | $ - | $ - | $ 30.00 | $ 50.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ 80.00 | $ 41.67 | $ 500.00 | ||
15 | Household Items(Dishes, Repair needs etc.) | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||
16 | Hygiene(Haircuts etc.) | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||
17 | Play(Vacation, Dates etc.) | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||
18 | Allowances | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||
19 | Toys(Phones, Computer Games etc) | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||
20 | Clothes | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||
21 | Car Maintance | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||
22 | Savings | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||||
23 | INCOME | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||||
24 | EXPENSES | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $5,625.00 | |||
25 | BALANCE | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||||
26 | SAVINGS BALANCE | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 266px;"><col style="width: 21px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 78px;"><col style="width: 106px;"><col style="width: 138px;"><col style="width: 128px;"></colgroup><tbody>
</tbody>