Budget spreadsheet help

[picoll012]

I have 4 cost centers each with their own budget. When I enter an amount spent against one of my cost centers I want to show the remaining spend for that cost centre. Is there a formula that can look up the CC number and the value entered against that CC and take it away from the total budget. For example CC 112 monthly budget is £1500, when I spend £50 I want that £50 to be taken off the budget for that month for CC 112 and so on... I have attached an excel sheet as an example.

 

[JamesCanale]

Is this what you want? Subtract the sum of the invoices for each cost center from the budget?

MrExcelPlayground4.xlsx
	A	B	C	D	E
1	Cost Center	Budget	Spent to Date	Remaining
2	112	$ 5,000.00	$ 915.00	$ 4,085.00
3	113	$ 4,000.00	$ 900.00	$ 3,100.00
4	114	$ 4,500.00	$ 1,190.00	$ 3,310.00
5	115	$ 3,500.00	$ 795.00	$ 2,705.00
6
7
8	Transactions
9	Stuff	Thing	Invoice	Cost Center	Amount
10	b	G	1	113	$ 150.00
11	c	H	2	112	$ 160.00
12	d	J	3	112	$ 140.00
13	b	G	4	114	$ 990.00
14	c	H	5	115	$ 50.00
15	d	J	6	112	$ 115.00
16	b	G	7	114	$ 200.00
17	c	H	8	112	$ 500.00
18	d	J	9	113	$ 150.00
19	b	G	10	113	$ 600.00
20	c	H	11	115	$ 625.00
21	d	J	12	115	$ 120.00
Sheet14

Cell Formulas
Range	Formula
C2:C5	C2	=SUMPRODUCT(--($D$10:$D$21=A2),$E$10:$E$21)
D2:D5	D2	=B2-C2