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