I have a list of data in rows with several rows being more or less a
duplicate of each other apart from some figures in one column. I want to be
able to add the figures together and end up with only one row for each set of
data. An added complication is that the data changes daily!!

e.g.
Data I have is:
Ref Name Amount
23 John 20.00
38 Steve 10.00
38 Steve 15.00

Result I need is:
Ref Name Amount
23 John 20.00
38 Steve 25.00

Thanks