sumif values in named ranges with same date

[rurounisena]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Misc[/TD]
[TD]Coded[/TD]
[TD]Priority[/TD]
[TD]Filing[/TD]
[/TR]
[TR]
[TD]6/3/2018[/TD]
[TD]44[/TD]
[TD]122[/TD]
[TD]3[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]6/4/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/5/2018[/TD]
[TD]55[/TD]
[TD]23[/TD]
[TD]45[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]6/6/2018[/TD]
[TD]90[/TD]
[TD]56[/TD]
[TD]33[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]6/7/2018[/TD]
[TD]65[/TD]
[TD]109[/TD]
[TD]34[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]6/8/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/9/2018[/TD]
[TD]44[/TD]
[TD]30[/TD]
[TD]4[/TD]
[TD]11[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 300"]
<tbody>[TR]
[TD]Date[/TD]
[TD]total[/TD]
[/TR]
[TR]
[TD]6/3/2018[/TD]
[TD]169[/TD]
[/TR]
[TR]
[TD]6/4/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/5/2018[/TD]
[TD]123[/TD]
[/TR]
[TR]
[TD]6/6/2018[/TD]
[TD]179[/TD]
[/TR]
[TR]
[TD]6/7/2018[/TD]
[TD]208[/TD]
[/TR]
[TR]
[TD]6/8/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/9/2018[/TD]
[TD]78[/TD]
[/TR]
</tbody>[/TABLE]

Above is a visual of what I'm trying to achieve. The first 3 cells to the right of a date added and placed in the cell next to the corresponding date on the second table. The tables are in different workbooks. I am pretty new to formulas in excel but it looks like the sumif function could help me? If someone could help me out or point me in the right direction I would really appreciate it

 

[KolGuyXcel]

If the columns are sorted or the column values have the same sequence in both the workbooks, try

=SUM([name of the workbook with the data]Name of the sheet!C4:E4)

If there's a space in the name of the workbook and/or the name of the sheet, then mention the corresponding name(s) within single quotes (')!

Along with the name of the workbook, you would need to add the complete path of the location of the workbook, like C:\Users\User1\Desktop\ etc.!