Hello,
I have a spreadsheet that has a lot of data. It has dollar amount in the
column A and and thier ssn in column B but some rows are duplicates but i
want to add the dollar amounts and delete the extra row to shorten the spread
sheet. please help

forgot to give you example.
A B
2799 123-45-6789
2344 123-45-6789
2312 123-45-2342
2344 123-45-2342
but thousands of lines like this and would like it to read.
A B
5143 123-45-6789
4656 123-45-2342
etc.