VLookup and Sum

[JTroy87]

I'm very new to VLookup so I'm not sure if this is the best way to go about this.

I have two sheets. My first sheet has job numbers and dates like below.

	1/1/2018			1/2/2018			1/3/2018
	January
jobNum	1			2			3
361421011
785221014
3067X4933
3067X4019

<tbody>
</tbody>

My second sheet has more job numbers, the date they were done, hours for each person on the job and whether the job was invoiced (marked with a U).

Job			Date		Invoice				Hours
3067X4019			01/01/18						3.00
3067X4019			01/01/18						5.00
3067X4019			01/03/18		U				4.00
597631589			01/04/18						7.00

<tbody>
</tbody>

My Goal is to find any job numbers on the first sheet, that are also on the second sheet, then to sum up all of the hours on a particular day. For example job number 3067X4019 had hours on 1/1/18 of 3 and 5, so the total on Sheet one would sum up to 8. Then there were 4 more hours on 1/3/18 so the end result for sheet one would look something like the below table. I would assume you do some combination of vlookup and sum but I have no idea how to account for the dates. Can someone please help?

	1/1/2018			1/2/2018			1/3/2018
	January
jobNum	1			2			3
361421011
785221014
3067X4933
3067X4019	8						4

<tbody>
</tbody>

 

[Weazel]

maybe something like...

obviously you would need to adapt it to your sheets

Unknown

	A	B	C	D	E	F	G	H	I
1		1/1/2018	1/2/2018	1/3/2018		Job	Date	Invoice	Hours
2			January			3067X4019	1/1/2018		3
3	jobNum	1	2	3		3067X4019	1/1/2018		5
4	361421011	0	0	0		3067X4019	1/3/2018	U	4
5	785221014	0	0	0		597631589	1/4/2018		7
6	3067X4933	0	0	0
7	3067X4019	8	0	4

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B4 =SUMPRODUCT(($F$2:$F$5=$A4)*($G$2:$G$5=B$1),$I$2:$I$5) <tbody> </tbody>

<tbody>
</tbody>

 

[JTroy87]

SUMIFS or SUMPRODUCT will both work. I don't know why I didn't think of that. I'm all good.

Thanks!