Need Formula Help

[amandaj1224]

I am in the process of creating a workbook to maintain my companies yearly budget. I have one tab that is an invoice tracker, which is a more refined view of what is being spent where I put all the information of an invoice paid, the period, and the cost center and GL I code it to. I have another sheet that keeps track of the budget on a less refined level.

Is there a formula I can use that would automatically populate and combine invoice amounts onto my budget sheet in the spent box based on what I enter for cost center, gl, and period?

 

[Toadstool]

Hi AmaandaJ1224,

SUMIFS should help.

AmandaJ1224.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2		720 - Uniforms and Safety Equipment
3
4	Period	1	2	3	4	5	6	7	8	9	10	11	12	13
5	CC230	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$888	$0	$372
6	CC320	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$444
7
8
9
10		PD	Amount	Cost Centre	Charged to
11		13	$222	CC230	720 - Uniforms and Safety Equipment
12		13	$444	CC320	720 - Uniforms and Safety Equipment
13		11	$888	CC230	720 - Uniforms and Safety Equipment
14		13	$150	CC230	720 - Uniforms and Safety Equipment
15		2	$12,500	CC320	880 - Management SPA Treatments
Sheet1

Cell Formulas
Range	Formula
B5:N6	B5	=SUMIFS($C$11:$C$9999,$B$11:$B$9999,B$4,$E$11:$E$9999,$B$2,$D$11:$D$9999,$A5)