roll up/consolidate rows with addition

Hello,

I'm working on writing some macros and I have a little trouble. My first thought was to use If then statements but since it appears you can not do if then then then then... statements I'm not sure how to accomplish my task with out a 200 line macro. I know scripting dictionaries could easily accomplish this but those are out of my skill set.

I am trying to roll up/consolidate rows based on a value in a certain column remaining the same. The column I am referring (A) to is actually a concatenation of 4 different columns.I added column (B) so I could easily pick these out of 200,000 plus rows. The tricky part is that there are a few columns that need to be summed up when they are rolled up/consolidated. These columns are (I), (J) and (K). The rest of the columns will remain the same so summing them up isn't required.

There are a small percent that are like this maybe 2 or 3% of 200,000+.

I've attached an example...Please let me know if you have any questions.