data table problem

Occasional Visitor

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

3 Replies

@Ali_Nadhum You sheet has formulae like:

={TABLE(,D3)}

 

TABLE is not an Excel function as far as I know. What is this supposed to do?

@Riny_van_Eekelen 

Hi Riny, see Data Tables 

@Ali_Nadhum 

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)