on my spreadsheet i have 3 columns; name, date, amount.
the names given are of only two people, and the sheet is in date order.

NAME DATE AMOUNT
smith 18.01.09 20
jones 19.01.09 4
smith 21.01.09 2
smith 29.01.09 3

i want to work out the overall amount for both names. how can i do this?