Excel Formula Sum Values If Then Formula

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).