Sum if data matches from multiple sheets

rgholmes08

New Member
Joined
Aug 4, 2014
Messages
1
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
 

Attachments

  • example 1.png
    example 1.png
    17.5 KB · Views: 9

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,656
Office Version
  1. 365
Platform
  1. Windows
What version of Excel are you running. If 2010 or later, you can append these tables quickly in Power Query.

 

Forum statistics

Threads
1,147,734
Messages
5,742,865
Members
423,760
Latest member
photogfrog

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
Top