Calculating totals for items with associated quantities over multiple rows

Hello everyone,
I have attached a sample spreadsheet in the hopes someone is able to assist me.

What I am trying to accomplish is to associate each product on the Distribution tab in 'E' to its associated quantity in 'F' so I can count the total number of each product and display this in 'D' on the Totals tab.

Once this is done, the total for each product would me multiplied by the associated price in 'C' on the Totals tab to achieve the total item value for each item in 'E'.

I have included the current results and what the correct values should be. As you can see, I tried to use 'Countif' with no success. I could not find any solutions in the forum that were close enough to this situation to work.

Thanks in advance for your help!!

Andrew