Lookup value in table if header date falls within this range

[B5rocksass]

I need to compile a list of item qtys across a weekly grid for reporting purposes. My original sheet is a list with duplicates. How do I arrive at the conclusion in the second table using formulas? Right now I'm doing this manually.

ITEM	QTY SHIPPED	IN-HOUSE DATE (OR EST)		WEEK START	1/22/17	1/29/17	2/5/17	2/12/17
DOG	500	25-Jan		DOG	750	350	0	500
HORSE	250	25-Jan		CAT	0	450	0	600
DOG	250	25-Jan		HORSE	1,250	0	0	600
CAT	500	25-Jan		PIG	550	250	0	200
HORSE	1,000	25-Jan
PIG	550	25-Jan
PIG	250	2-Feb
DOG	350	2-Feb
CAT	450	2-Feb
DOG	500	16-Feb
CAT	600	16-Feb
HORSE	600	16-Feb
PIG	200	16-Feb

<tbody>
</tbody>

 

[Momentman]

The cell coloured yellow should be 500, you have it as 0 in your sample

Excel 2010
	A	B	C	D	E	F	G	H	I	J
1	ITEM	QTY SHIPPED	IN-HOUSE DATE (OR EST)		WEEK START	22-Jan	29-Jan-17	05-Feb	12-Feb-17	19-Feb
2	DOG	500	25-Jan		DOG	750	350	0	500
3	HORSE	250	25-Jan		CAT	500	450	0	600
4	DOG	250	25-Jan		HORSE	1250	0	0	600
5	CAT	500	25-Jan		PIG	550	250	0	200
6	HORSE	1,000	25-Jan
7	PIG	550	25-Jan
8	PIG	250	02-Feb
9	DOG	350	02-Feb
10	CAT	450	02-Feb
11	DOG	500	16-Feb
12	CAT	600	16-Feb
13	HORSE	600	16-Feb
14	PIG	200	16-Feb
Sheet6

Cell Formulas
Range	Formula
F2	=SUMIFS($B$2:$B$14,$A$2:$A$14,$E2,$C$2:$C$14,">="&F$1,$C$2:$C$14,"<"&G$1)

 

[B5rocksass]

YOU ARE A GENIUS! Thank you so much!!