Nested IF with SUMIFS conditions

Hello,   Below is my formula in excel. The yellow color cell is the data validation list. Could anyone help me check what is going on with the formula? Because when I try to select a different dist...