How many columns of data do you have ?? If you sort the data by Name, and then perform a subtotal that Adds the value after each change in name, the collapsed list should show something like :
Mr John Smith Total £500.00
Mr Paul Brown Total £750.00
What version of Excel are you using ?