Sum Cells based on a Unique Record

[basmster]

Hi folks.

Thanks in advance for this help. I think this is an easy question but I'm still a beginner with VBA.

In the .xlsb I attached, take a look at Sheet Orders4SF, columns F-K. You'll see simple sum functions in columns G-K to show what I want the code to do. Basically, I want Excel to add up the values in the "2.Orders" spreadsheet based on a unique contact record. So when a new value for column K (email) is populated, the code will start adding up the values in L, and in M, N, etc...just the way it is displayed in the workbook. I'd also like only two contact records (in this example) to populate in the Contacts4SF sheet and don't know how to do that. This excel workbook is meant to be imported into a database and I'm basically trying to query the records I want in Excel.

Thank you very much and let me know if this isn't clear.