VLOOKUP and sum

AndersNOR9

New Member
Joined
Nov 13, 2017
Messages
20
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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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.
 
Upvote 0

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,559
Latest member
MrPJ_Harper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top