Sum if data matches from multiple sheets

[rgholmes08]

Good morning all!

Trying to combine some data from multiple manufacturing plants and struggling to figure out the best way to hopefully make it repeatable when I run these reports. Essentially I am pulling a sheet from two location and each sheet has a column for part number, description, and quantity sold. Each plant does sometimes sell the same things but they do also have unique items they sell as well. My goal is on a 3rd sheet to combine and total any of the same part numbers sold quantity, and then any unique items for each plant to be brought over as well so I have a total view of items sold across the company. I tried to include a manual example of what I'd be looking for in an image. Let me know if I need to provide any additional details.

Thanks!
Ryan

 

[alansidman]

What version of Excel are you running. If 2010 or later, you can append these tables quickly in Power Query.