Excel VBA: Sum Expense/Revenue Data Based on Unique Customer Owner Value

Hello Forum and thank you very much in advance for taking a look at my request for VBA code to solve a business problem...

I'm working on a profitability report by analyzing expenses and revenues of customers by customer owner. I have a data set of hundreds of thousands of rows that contain customers (column A), customer owners (column B), dollars in expenses (column C), and dollars in revenues (column D). There are one or more customers for each customer owner (so I fully expect there to be multiple instances of results in the output for owners with more than one customer). Each customer has its own expense and revenue dollar amount.

I would like to create a macro button that does the following. For each customer owner, lookup all of their associated customers then:

1. Total the customer expenses (C) for that customer owner and place that total in column E for that customer owner ID in that row, and
2. Total the customer revenues (D) for that customer owner and place that total in column F for that customer owner ID in that row

Again, expectation is that there will be duplicate values in columns E and F where a customer owner has more than one customer. I have attached a sample workbook that demonstrates the expected results in columns E and F. Note the actual workbook will not necessarily have the data in adjacent columns, so absolute references are likely preferred (as if I know what I'm even talking about! ).

Thanks so much and please let know if I can clarify anything better than I have here already.

Regards,
Chris

Thanks for the quick reply Ford! I'm working in a workbook with over 500K rows of data, I'm concerned about the time it might take to run a formula like this for each lookup value. I'm not at work right now, so I can't try it until tomorrow. Do you think it will not be a problem with that many rows? I'm a little gun shy since I tried something simlar with an array formula once before and it would literally take hours (like overnight!) to run. Any feedback is appreciated.

Thanks!
Chris

Cool, I believe you're right on the calculation as it literally locked up on me many, many times. I'll try it in the morning and post back. I surely don't need elegant for this by any means as I'll turn around and copy/paste as values after getting the results. Appreciate it, thanks again.

Good morning Ford...so the formula, as expected, works! That's the good news.

The bad news, as feared, is that it's moving at a crawl speed to calculate of about 2% every minute and I can't do anything else in Excel while it does its work. This will take hours.

Any thoughts on a code that might do the same trick in a few seconds or minutes? Appreciate your patience with me.

Thanks,
Chris