Add up totals in a row then delete duplicates

[martinez_pedro]

Hi Everyone
Does anybody have a macro that can add up the totals?
i have a spreadsheet that i receive all the time and i have to add the totals manually some times there is few account and sometimes there is 100 of accounts
So basically what i do is find the duplicate account numbers (in column A) then add up the equipment charge (in column P) and then i delete the duplicate account number and keep one of the rows with the add up total
if someone knows how to do it I really appreciated thanks a bunch
oh also i attach a sample workbooks so you can see what i am talking about

[nilem]

Maybe so (for Excel 2007/10)

Please Login or Register  to view this content.

[martinez_pedro]

Excellent it worked perfectly i just try it in the original file and it works thank you very much