SOLVED

# Excel Formula Sum Values If Then Formula

Copper Contributor

# Excel Formula Sum Values If Then Formula

Hand written notes on what I need the excel formula to do.

I need to take the total amount needed and subtract that from the amount received under the condition that the column color 1 (Column A41 :75) & the column color 2 (Column B41:75) matches the colors shown in Column A19:33 and Column B19:33.

The table shown at the top of the page is the total amount needed. The middle table is where the formula is needed - so I can figure out how much more of each type I need to receive.

The bottom table is the qty I received of each type (color 1 = Blue and color 2 = Red is one type of material, color 1 = Blue and color 2 = Yellow is a different type of material).

2 Replies
best response confirmed by kampstra (Copper Contributor)
Solution

# Re: Excel Formula Sum Values If Then Formula

Does the attached example return the intended result?

# Re: Excel Formula Sum Values If Then Formula

Yes it does, thanks for the assist!
1 best response

Accepted Solutions
best response confirmed by kampstra (Copper Contributor)
Solution

# Re: Excel Formula Sum Values If Then Formula

Does the attached example return the intended result?