Add onto a formula to link a value based on a dropdown menu selection

Morning All,

Im in the process of trying to make a budgeting spreadsheet. I have a deposit column and then I also have 5 columns with breakdowns or subaccounts from the main deposit. So basically for the first sub account I have =.6*SUM(deposit column) because I want that account to hold 60% of everything I put in as a deposit. I go on to breakdown each subaccount like this and those seem to work great so far.

Now where Im running into issues.... I have another table with a column for withdrawal amounts and a dropdown to indicate which sub-account I'm withdrawing from. So say that first subaccount mentioned above is titled "Down Payment" How do I add to the formula above to account for withdrawals if a line in that table is added with the "down payment" subaccount selected?

Hopefully that makes sense and if not I can expand!

Thanks so much!

Quite honestly a sample file with expected results and why would help tremendously in this case.

Note: Thank you for the title change

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Anyway, what I would do is to define coefficients above each column.
Then you can use same formula for all your columns and also change coefficient without chaning formula.

Formula:

=G$3*SUM($A$3:$A$18)-SUMIF($B$20:$B$40,G$4,$A$20:$A$40)

I don't know did I get it but maybe this:

Add -SUMIF($B$20:$B$40, G$4, $A$20:$A$40) at the end of eoach of your formulae.