SumIF for multiple IF's with multiple IF's

[biglb79]

can someone please help me out with a formula here? I want to sum census days from a pivot table. in column A there are three different regions (Akron, Columbus and Cleveland). in column B I have four different programs (IOP, Outpatient, PHP and Assessment) and in column C I have different financial codes (COMM, MGD MCAID and MCAID)

The days are counted in column AF, so I would like it to SumIF it's Akron, IOP and MCAID. Akron, IOP MGD MCAID, Akron IOP COMM, etc.....

Hopefully I described what I'm looking for. if not I can attach some dummy sheet (after removing sensitive data)

 

[JamesCanale]

Sumproduct is your friend for old excel.

MrExcelPlayground24.xlsx
	A	B	C	D	E	F	G	H	I
1	Region	Program	Codes	days
2	Akron	IOP	MCAID	6			Region	Akron
3	Columbus	Out	MCAID	4			Program	IOP	6
4	Cleveland	PHP	COMM	3			Code	MCAID
5	Columbus	***	MGD	6
6	Akron	***	COMM	4
7	Columbus	Out	MGD	1
8	Columbus	IOP	MGD	2
9	Akron	PHP	MCAID	7
10	Akron	PHP	MGD	1
11	Cleveland	***	COMM	2
12	Cleveland	Out	MGD	3
13	Columbus	PHP	MCAID	4
14	Akron	***	COMM	5
15	Cleveland	Out	MCAID	6
16	Akron	PHP	MGD	7
Sheet7

Cell Formulas
Range	Formula
I3	I3	=SUMPRODUCT(D2:D16,--(A2:A16=H2),--(B2:B16=H3),--(C2:C16=H4))