Automatically calculating remaining budgets with multiple criteria

[DavidMantle]

I have a spreadsheet with approximately 20 different tabs, each having a separate budget that is split into 3 sections. I've also got a master tab that I'm looking log all transactions/invoices related to any or all of the budgets on all the tabs. I would like to create a formula that automatically deducts the relevant amounts from the relevant budgets, based on 2 criteria - so in simple terms I would like it to be as follows: If Column A has a text value of x and Column B has a text value of y then deduct the numerical value entered in Column C from the overall budget figure in Column D and display as a running total in Column E. There are 3 options for the type of transaction and about 14 options for the relevant budget figure.
Is it possible to create something in Excel that can automatically update a remaining budget figure based on criteria entered in a transaction log which subtracts the related figure from the original budget figure?