OK HERE WE GO AGAIN!!

I have a Validation List with about 20 different names in it.

In the list the name maybe displayed more than once. After each name there
is a total.

So Say

David £5.00
Richard £7.00
Ben £15.00
Gary £100.0
David £75.00
David £5.00
Richard £21.50
Ben £56.84

What i need to do is a do a sumary at the bottom of the work sheet. I have
put the whole list at the bottom and need to put a function in the total
amount for each person.

E.g.David - £85.00
Richard £28.50
Ben £71.84

What is the function. Say the name is colum B and the amount is colum E

Cheers

David