Sep 28 2021 10:39 AM
Sep 28 2021 11:29 AM
The formulas in C18:C24 refer D3, and D3 also influences the result of D10:H10 and hence the result of =SUM(D11:H11). This causes a conflict.
Either replace the formulas in C18:C24 with their values, or change the formulas so that they don't relate directly or indirectly to cells that affect the outcome of =SUM(D11:H11)