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!