sumifs() across tables

[sstiebinger]

I have a couple of tables and I need to sum if based on multiple criteria within these tables.

Table 1 - Sales History:

Item ID	Order Date	Units Sold
40916	4/4/2018	1
41444	5/2/2018	3

<tbody>
</tbody>

Table 2 - Promos:

Item ID	Promo Start Date	Promo End Date	Sales during period
40916	4/1/2018	4/30/2018	???
22273	4/1/2018	4/30/2018	???

<tbody>
</tbody>

For Sales During Period I would like the sum of all units sold where:
Table2[Item ID] = Table1[Item ID]
AND
Table1[Order Date] >= Table2[Promo Start Date]
AND
Table1[Order Date] <= Table2[Promo End Date]

I can't figure out the sumifs statement...

Thanks in advance for the help!

 

[Chameleon64]

=SUMIFS(Table1[Units Sold],Table1[Item ID],[@[Item ID]],Table1[Order Date],">="&[@[Promo Start Date]],Table1[Order Date],"<="&[@[Promo End Date]])

 

[sstiebinger]

Thanks!

I was missing the quotes around the operators and the &... didn't realize I needed to send that as a string....

Always learning.