Forum Discussion
data table problem
Hi all! why the results of data table are wrong when I use an equation in input column and they are correct when I use numbers as shown in the example of summation below
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)