Sumproduct

Hello friends,

I need help with finding the sum of the suppliers in my spreadsheet attached. Suppliers apperaing more than once should appear once in the result. The answer should appear on a separate sheet with one column showing the supplier names and the other showing the totals of each supplier. I also need to show the grand total. The SUMPRODUCT FUNCTION must be used...... please help.