SOLVED

# Returning a value after matching multiple criteria

Copper Contributor

# Returning a value after matching multiple criteria

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.

5 Replies
best response confirmed by HansVogelaar (MVP)
Solution

# Re: Returning a value after matching multiple criteria

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

# Re: Returning a value after matching multiple criteria

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

# Re: Returning a value after matching multiple criteria

I did not mention the IFS() function.

# Re: Returning a value after matching multiple criteria

Thank you.  It is working.

# Re: Returning a value after matching multiple criteria

Thank you. It is working.
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

# Re: Returning a value after matching multiple criteria

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