Create a single record with total sum of sales

Hi All, I have a long list of customers and the projects they have signed off with us ($ amount). Customers can have multiple entries for different projects ($ amount). What I would like is to create a list of a single record for each customer and the total $ amount for this customer based on the first list. I've been scratching my head how to do this but I cannot think of a solution.

theres a couple of alternatives - have a look here

theres a suggestion by me in the post my post #7
http://www.excelforum.com/excel-form...html?p=3155553
to extract unique values from the list and then use Sumif to get the totals

However, Kevin UK in post #17 has provided an alternative

let us know if that helps - if not
post your exact requirements and a sample spreadsheet