If your list is in A1:B20 and your summary starts in A30, enter in B30 and
copy down:

=SUMIF(A$1:A$20,A30,B$1:B$20)

where A30 and the cells below contain the names.

--

Vasant



"David Harrison" wrote in message
...
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