Thread: Sorting out duplicate cells in summary table

I have a spreadsheet where users are entering in lot numbers (Feedstock lot #) in the left, choosing the type of lot number from a drop down menu, and listing either the amount of kilograms or drum numbers from that lot in the right. They may choose the same lot number more than once as their material source.
Here's the problem - I'm making a summary table below the table they're filling out. This summary table will list each of the feedstock lot numbers only once and will total the quantity used from that specific lot. I've searched through most functions and misc. options and have not yet found out how to do this. Any ideas?

The spreadsheet is attached and contains macros.

Thanks