Sum Total Based on Multiple Criteria and in two sources

[Nickvv]

I'm trying to get a column with the total number of cars received based:

From source 1 and Source 2

IF Date Sold + PO + Class + Item and return the total cars received on the same date as PO Sold + Class + Item 

Source 1: (Sales Tab in Excel)

Unique ID	PO	Date Sold	Class	Item	Cars Sold
1	11	1-Oct	GM	Sierra	3
2	22	2-Oct	GM	Envoy	1
3	33	3-Oct	Ford	Mustang	1
4	44	4-Oct	Ford	Mustang	5
5	55	5-Oct	Chevy	Silverado	10
6	66	6-Oct	Chevy	Tahoe	1

Source 2: (Orders Tab on Excel)

PO	Date Received	Class	Item	Cars Received
11	1-Aug	GM	Sierra	75
77	1-Aug	GM	Sierra	75
22	2-Aug	GM	Envoy	88
88	2-Aug	GM	Envoy	88
33	3-Aug	Ford	Mustang	100
99	3-Aug	Ford	Mustang	100
44	4-Aug	Ford	Mustang	50
55	5-Aug	Chevy	Silverado	60
66	6-Aug	Chevy	Tahoe	10

What i want my final result to be: (Final tab in Excel)

Unique ID	PO	Date Sold	Class	Item	Cars Sold	Date Received	Cars Received
1	11	1-Oct	GM	Sierra	3	1-Aug	150
2	22	2-Oct	GM	Envoy	1	2-Aug	176
3	33	3-Oct	Ford	Mustang	1	3-Aug	200
4	44	4-Oct	Ford	Mustang	5	4-Aug	50
5	55	5-Oct	Chevy	Silverado	10	5-Aug	60
6	66	6-Oct	Chevy	Tahoe	1	6-Aug	10

[Kenda · Accepted solution]

Hey @Nickvv 

Here is how I approached this problem. It works for the sample dataset that you provided. Hopefully this helps with your entire dataset, too!

[christine_assaad]

Hi @Nickvv 

Please check the attached. Cheers!