I have two columns

one has "id" and column 2 has amount

a 5
b 10
c 15
a 5
c 15

All id has same amount.
what I want is total of all unique id's
i.e. 30 in this case

The number of rows/ records can go up and down.
any takers?