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.

	4/22/2018	4/23/2018	4/24/2018	4/25/2018	4/26/2018	4/27/2018	4/28/2018
Lbs used
Cases	5,000	9,000	7,000	8,750	15,472
Raw Data Table			Vlook up table
Date	Product	lbs			Product	Lbs / case
4/22/2018	abc	1,587			abc	5
4/22/2018	xyz	1,589			XYZ	7
4/22/2018	abc	5,484
4/23/2018	abc	4,120
4/23/2018	xyz	2,358
4/23/2018	abc	5,875
4/24/2018	abc	5,486
4/24/2018	xyz	9,878
4/25/2018	abc	9,852
4/25/2018	abc	3,547
4/26/2018	abc	3,487
4/26/2018	xyz	8,575

<colgroup><col span="8"></colgroup><tbody>
</tbody>

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.