multiple column sum product based on set criteria

Morning all

I have an array of information that i have to crunch daily and i would olike to speed the process up by creating a table i can upload the data to on a day by day basis that will auto generate the results i want please. Basically i require a total weight by type split by shift in order to see how each shift is performing on each type of product required.

I have created a basic mock up of the data and the result i hope to achieve which should explain far easier than trying to in words hopefully.

Thank you in advance

Damion