finding the difference each month?

Wens

New Member
Joined
Jun 4, 2012
Messages
16
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

ABCDEFGHIJKLMNOPQR
12012 SUMMARY/TOTALS
2Category Initial Balance JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC YTD Difference Planned Amounts/Month Planned Amounts/Year
3Work Expenses $ - $ - $ - $ - $ 300.00 $ 250.00 $ - $ - $ - $ - $ - $ - $ 550.00 $ 250.00 $ 3,000.00
4General Groceries $ - $ - $ - $ - $ 1,200.00 $ 1,500.00 $ - $ - $ - $ - $ - $ - $ 2,700.00 $ 1,250.00 $ 15,000.00
5Take Away $ - $ - $ - $ - $ 150.00 $ 200.00 $ - $ - $ - $ - $ - $ - $ 350.00 $ 166.67 $ 2,000.00
6Kids Activites $ - $ - $ - $ - $ 400.00 $ 300.00 $ - $ - $ - $ - $ - $ - $ 700.00 $ 333.33 $ 4,000.00
7Petrol $ - $ - $ - $ - $ 550.00 $ 600.00 $ - $ - $ - $ - $ - $ - $ 1,150.00 $ 583.33 $ 7,000.00
8Rent $ - $ - $ - $ - $ 1,600.00 $ 1,600.00 $ - $ - $ - $ - $ - $ - $ 3,200.00 $ 1,666.67 $ 20,000.00
9School Expenses(Books, Fees etc.) $ - $ - $ - $ - $ 50.00 $ 100.00 $ - $ - $ - $ - $ - $ - $ 150.00 $ 83.33 $ 1,000.00
10Debt Payments(Credit Card, Loans etc.) $ - $ - $ - $ - $ 150.00 $ 200.00 $ - $ - $ - $ - $ - $ - $ 350.00 $ 250.00 $ 3,000.00
11Regular Bills(Phone, Utilities, Insurance etc.) $ - $ - $ - $ - $ 400.00 $ 700.00 $ - $ - $ - $ - $ - $ - $ 1,100.00 $ 583.33 $ 7,000.00
12Miscellaneous $ - $ - $ - $ - $ 200.00 $ 100.00 $ - $ - $ - $ - $ - $ - $ 300.00 $ 166.67 $ 2,000.00
13Gifts(Birthdays, Christmas etc.) $ - $ - $ - $ - $ 300.00 $ 250.00 $ - $ - $ - $ - $ - $ - $ 550.00 $ 250.00 $ 3,000.00
14Health Expenses(Prescriptions, Dentist, Doctor etc.) $ - $ - $ - $ - $ 30.00 $ 50.00 $ - $ - $ - $ - $ - $ - $ 80.00 $ 41.67 $ 500.00
15Household Items(Dishes, Repair needs etc.) $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
16Hygiene(Haircuts etc.) $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
17Play(Vacation, Dates etc.) $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
18Allowances $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
19Toys(Phones, Computer Games etc) $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
20Clothes $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
21Car Maintance $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
22Savings $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
23INCOME $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
24EXPENSES $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $5,625.00
25BALANCE $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
26SAVINGS 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>
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,221,418
Messages
6,159,790
Members
451,589
Latest member
Harold14

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top