data table problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2792647%22%20slang%3D%22en-US%22%3Edata%20table%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2792647%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all!%20why%20the%20results%20of%20data%20table%20are%20wrong%20when%20I%20use%20an%20equation%20in%20input%20column%20and%20they%20are%20correct%20when%20I%20use%20numbers%20as%20shown%20in%20the%20example%20of%20summation%20below%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2792647%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2792780%22%20slang%3D%22en-US%22%3ERe%3A%20data%20table%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2792780%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1169159%22%20target%3D%22_blank%22%3E%40Ali_Nadhum%3C%2FA%3E%26nbsp%3BYou%20sheet%20has%20formulae%20like%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%7BTABLE(%2CD3)%7D%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETABLE%20is%20not%20an%20Excel%20function%20as%20far%20as%20I%20know.%20What%20is%20this%20supposed%20to%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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)