SOLVED

Returning a value after matching multiple criteria

Copper Contributor

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.    

 

rossshah_0-1683297712191.png

 

5 Replies
best response confirmed by HansVogelaar (MVP)
Solution

@rossshah 

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

 

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

@rossshah 

 

I did not mention the IFS() function.

 

 

rossshah_0-1683303500845.png

Thank you.  It is working.

 

Thank you. It is working.
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

@rossshah 

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

 

View solution in original post