sumif issues

[bigry26]

I have some data that I need to find out what the total for the lbs used for each day equates to? Thanks in advance.

[TABLE="width: 544"]
<colgroup><col span="8"></colgroup><tbody>[TR]
[TD] [/TD]
[TD="align: right"]4/22/2018[/TD]
[TD="align: right"]4/23/2018[/TD]
[TD="align: right"]4/24/2018[/TD]
[TD="align: right"]4/25/2018[/TD]
[TD="align: right"]4/26/2018[/TD]
[TD="align: right"]4/27/2018[/TD]
[TD="align: right"]4/28/2018[/TD]
[/TR]
[TR]
[TD]Lbs used[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Cases[/TD]
[TD="align: right"]5,000[/TD]
[TD="align: right"]9,000[/TD]
[TD="align: right"]7,000[/TD]
[TD="align: right"]8,750[/TD]
[TD="align: right"]15,472[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]Raw Data Table[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Vlook up table[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]Product[/TD]
[TD]lbs[/TD]
[TD][/TD]
[TD][/TD]
[TD]Product[/TD]
[TD]Lbs / case[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/22/2018[/TD]
[TD]abc[/TD]
[TD="align: right"]1,587[/TD]
[TD][/TD]
[TD][/TD]
[TD]abc[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/22/2018[/TD]
[TD]xyz[/TD]
[TD="align: right"]1,589[/TD]
[TD][/TD]
[TD][/TD]
[TD]XYZ[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/22/2018[/TD]
[TD]abc[/TD]
[TD="align: right"]5,484[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/23/2018[/TD]
[TD]abc[/TD]
[TD="align: right"]4,120[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/23/2018[/TD]
[TD]xyz[/TD]
[TD="align: right"]2,358[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/23/2018[/TD]
[TD]abc[/TD]
[TD="align: right"]5,875[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/24/2018[/TD]
[TD]abc[/TD]
[TD="align: right"]5,486[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/24/2018[/TD]
[TD]xyz[/TD]
[TD="align: right"]9,878[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/25/2018[/TD]
[TD]abc[/TD]
[TD="align: right"]9,852[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/25/2018[/TD]
[TD]abc[/TD]
[TD="align: right"]3,547[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/26/2018[/TD]
[TD]abc[/TD]
[TD="align: right"]3,487[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/26/2018[/TD]
[TD]xyz[/TD]
[TD="align: right"]8,575[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Sincerely,

Big Ry

 

[JoeMo]

Copy B2 to the right.

Excel Workbook
	A	B	C	D	E	F	G	H
1		4/22/2018	4/23/2018	4/24/2018	4/25/2018	4/26/2018	4/27/2018	4/28/2018
2	Lbs used	8660	12353	15364	13399	12062	0	0
3	Cases	5,000	9,000	7,000	8,750	15,472
4
5
6	Raw Data Table					Vlook up table
7	Date	Product	lbs			Product	Lbs / case
8	4/22/2018	abc	1,587			abc	5
9	4/22/2018	xyz	1,589			XYZ	7
10	4/22/2018	abc	5,484
11	4/23/2018	abc	4,120
12	4/23/2018	xyz	2,358
13	4/23/2018	abc	5,875
14	4/24/2018	abc	5,486
15	4/24/2018	xyz	9,878
16	4/25/2018	abc	9,852
17	4/25/2018	abc	3,547
18	4/26/2018	abc	3,487
19	4/26/2018	xyz	8,575
Sheet4

 

[bigry26]

Thank you very much Joe! I was over complicating it.

 

[JoeMo]

You are welcome - thanks for the reply.