Hi

I have a spreadsheet with two main columns the first column contains names of customers (5,000 in total). The second column contains details of all the investment products they have purchased on a product by product basis.

I want to consolidate the sheet to show each customer's name only once and to add all the products for this customer thereby moving from a product-by-product basis to a portfolio basis.

For example if Mr A purchased products in 2005,2006 and 2007 for £50k, £50k and £50k his name will appear three times. I want it to appear only once and to add all the products he purchased to show Mr A £150k.

I have tried various permutations of SUMIF and COUNTIF but am slightly stuck.

Any suggestions?

Thx