VLOOKUP and sum

[AndersNOR9]

Hi,

I got a worksheet "Data", in column A I have the names of customers. In column B I have the sku´s and product name for each product that customer buys and in C I have the sum for each product.

I have a sheet "summary" where all the customer names are listed (with no space between them) in column A. I want to have the sum of all the product the customers buys in column B.

See example of "Data" sheet.

https://imgur.com/a/9PVxr6b

 

[AndersNOR9]

Here is how I want the "summary" sheet to be. There are a total of 10 000 lines in the Data sheet btw.

https://imgur.com/a/9PVxr6b

 

[Joyner]

Hello, I'm sure you can get a formula solution if that is what you want. If it were we, I would clean up your data into a proper data set, if it is as you show it would only take about two minutes - filling blanks on the customer name, deleting the blank rows between customers and you are done.

Then you can use a Pivot Table to do what you want and anything else you may want to, like sum on SKU/Product or any other fields you may have.

Just my thoughts.