Sum TWO columns and delete rows

[cdrobinson83]

Hi,

I'm trying to figure out how I can sum columns I and J while deleting the rows in the process that are deemed duplicates. Match criteria are columns A,C,E,F,H,K, and L. Example below of what I'm trying to do. Is anyone able to help? I can't for the life of me figure it out. I've looked at other posts and I just can't apply the logic.

Before:

After:

 

[cdrobinson83]

Thank you again for all of this. Unfortunately getting the below error, while also missing columns from the original data.

 

[alansidman]

That is because you have both those fields identified as Text. Change to whole numbers or decimal. You cannot sum text. Click on the ABC in the field header and on the drop down select the numbers format you wish. Do this after the Source line. It is the same line as I have called ""Changed Type"

Here is a link to the file that contains your data that I worked on

PQ group and sum.xlsx | Powered by Box

app.box.com