Help! Multiple Criteria

[Ryske]

Hello everyone, hope all is well. I will be making a presentation – automated gathering of info. I just can’t figure out how to make this happen.
The first spreadsheet would be the output, the date on the top are the ship dates. I have customers that are ordering 2 items irregularly, need to track their orders.

	1-Jan-17	2-Jan-17	3-Jan-17	4-Jan-17	5-Jan-17	6-Jan-17	7-Jan-17
Customer	Item 1	Item 2	Item 1	Item 2	Item 1	Item 2	Item 1	Item 2	Item 1	Item 2	Item 1	Item 2	Item 1	Item 2
Company A	10	-	-	-	-	-	-	-	-	-	-	-	-	50
Company B	-	-	-	-	-	20	-	-	-	-	-	-	-	-
Company C	-	-	-	-	-	-	-	-	20	20	-	-	-	-

<colgroup><col><col span="14"></colgroup><tbody>
</tbody>

Second spreadsheet is the raw data:

Customer	Item	Ship date	Quantity
Company A	Item 1	1-Jan-17	10
Company B	Item 2	3-Jan-17	20
Company C	Item 1	5-Jan-17	20
Company C	Item 2	5-Jan-17	20
Company A	Item 2	7-Jan-17	50

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Is there a simple formula for this? Any help would be greatly appreciated. Thanks in advance!

 

[Jeffrey Mahoney]

A SUMIFS formula will do. Assume "Customer" is in cell A2 for the top table. Assume the bottom table is on sheet4. Do in this order...

Cell B3 formula: =SUMIFS(Sheet4!$D$1:$D$6,Sheet4!$A$1:$A$6,Sheet3!$A3,Sheet4!$C$1:$C$6,Sheet3!B$1,Sheet4!$B$1:$B$6,Sheet3!B$2)
Cell C3 formula: =SUMIFS(Sheet4!$D$1:$D$6,Sheet4!$A$1:$A$6,Sheet3!$A3,Sheet4!$C$1:$C$6,Sheet3!B$1,Sheet4!$B$1:$B$6,Sheet3!C$2)

Copy those two formulas down to the next rows

Copy those two columns of formulas and paste into Cells D3, F3, H3, J3, L3, and N3

TA DA

 

[Ryske]

Hi Jeffrey, thanks for the response. I understand now how the sumifs works, however, the dates top of the first image are merged cells for example "1-Jan-2017 is located in B1:C1". My apologies if I missed this on my first post. I cannot attach the actual spreadsheets I am working on, my access on this is disabled. Thank you!