Excel Formula Sum Values If Then Formula

[kampstra]

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 · Accepted solution]

@kampstra 

Does the attached example return the intended result?

[#3]

Yes it does, thanks for the assist!