Returning a value after matching multiple criteria

[rossshah]

Looking for a formula on cell "I2".  Blue Bike and Press from Table 1 need to match Blue Bike and Press from Table 2, then cell "I2" needs to return a value with qty of 3.   I don't have IFS function available.  Thank you.    

[#2 · Accepted solution]

@rossshah 

=SUMIFS(Qty,Part_#,F2,Machine,G2)

[#3]

Thank you but I have Excel 2016. I don't have IFS function.

[#4]

@rossshah 

I did not mention the IFS() function.

[#5]

Thank you.  It is working.

[#6]

Thank you. It is working.