Sum, Merge and Delete Duplicate Rows

[astoria]

My Worksheet Contains Following Columns

sr no. | name | rate | add this | add this | add this |.......


Need a Macro to Compare Name and Rate and If same Name and rate is Found same for 2 or more rows Retain First Sr no. , name , rate and add all other columns and then delete duplicate rows

Here is the Example Of what i want


sr no | name | rate | add this | add this

1 abc 100 50 10
2 xyz 100 10 30
3 abc 100 60 20
4 pqr 100 25 40
5 abc 250 10 15

I want this to be Converted To

sr no | name | rate | add this | add this

1 abc 100 110 30
2 xyz 100 10 30
4 pqr 100 25 40
5 abc 250 10 15

i.e rows are added and merged only when name and rates both match and also sr no. must not be changed

(Also there can be n columns out of which except first 3 all other cols must be added)