Sumifs, Lists, and Sumproduct to create a matrix?

[rgsanchez]

Hello,
I am trying to create a matrix that includes specific data from different Excel workbooks. However, since I don't know how to use macros, I'm going to transfer data from each workbook to the appropriate day column in my matrix, one by one.

I will use trains carrying food products as my example. There are "fruit trains" carrying fruits, and there are other trains (like rice or beans). I only want to include data about fruit trains in my matrix. By train number, and the day of week the train operated, I want to sum the total minutes of delay that each train experienced as it traveled to it's final destination. I cannot change the format/layout of my final matrix.

I think I need to use combinations of sumifs and sumproduct, but I haven't found something that works for my specific situation.


MATRIX: Fruit Train Delays

		8/1/2019 <tbody> </tbody>	8/2/2019 <tbody> </tbody>	8/3/2019 <tbody> </tbody>
	Train #	M-F <tbody> </tbody>	M-F <tbody> </tbody>	SatSun
M-F	561 <tbody> </tbody>	7	formula?
SatSun	561 <tbody> </tbody>	0	formula?
M-F	562 <tbody> </tbody>	5	formula?
SatSun	562 <tbody> </tbody>	0
M-F	564 <tbody> </tbody>	0
SatSun	1564	0
M-F	763 <tbody> </tbody>	4
SatSun	763 <tbody> </tbody>	0

<tbody>
</tbody>

8/1/19 Report <tbody> </tbody>

<tbody>
</tbody>

Train #	Product	MinsDelayed
561	Grapes	5
561	Kiwis	2
562	Apples	5
562	Rice	1
564	Beans	1
1564	Apples	0
763	Kiwis	4
763	Rice	3

<tbody>
</tbody>

Fruits List:

Grape

Kiwi

Apple

Orange

Grape

<tbody>
</tbody>

Any help would be much appreciated! Thank you.