SOLVED

Formula will not sum a row of data drawn from a sheet in same workbook and returns zero

%3CLINGO-SUB%20id%3D%22lingo-sub-1620622%22%20slang%3D%22en-US%22%3EFormula%20will%20not%20sum%20a%20row%20of%20data%20drawn%20from%20a%20sheet%20in%20same%20workbook%20and%20returns%20zero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620622%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Adapt%20calc.PNG%22%20style%3D%22width%3A%20883px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F215363i1E82E0E5920D8F10%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Adapt%20calc.PNG%22%20alt%3D%22Adapt%20calc.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%40The%20formula%20in%20the%20yellow%20columns%20is%20%3DSUM(ADAPT%5B%40%5BOwning%20Opportunities%5D%3A%5BPersonal%20Leadership%5D%5D)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1620622%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620643%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20will%20not%20sum%20a%20row%20of%20data%20drawn%20from%20a%20sheet%20in%20same%20workbook%20and%20returns%20zero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620643%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767668%22%20target%3D%22_blank%22%3E%40Hewtee%3C%2FA%3E%26nbsp%3BPerhaps%20the%20numbers%20you%20are%20summing%20are%20in%20fact%20texts.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620712%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20will%20not%20sum%20a%20row%20of%20data%20drawn%20from%20a%20sheet%20in%20same%20workbook%20and%20returns%20zero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620712%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20Thanks.%20I%20checked%20the%20cells%20are%20formatted%20as%20numbers%3F%26nbsp%3B%20The%20formula%20inside%20each%20is%26nbsp%3B%3DALL!AL2%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620721%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20will%20not%20sum%20a%20row%20of%20data%20drawn%20from%20a%20sheet%20in%20same%20workbook%20and%20returns%20zero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620721%22%20slang%3D%22en-US%22%3EI%20just%20forunsd%20the%20answer%20I%20have%20to%20add%20*1%20to%20the%20formula.%20Thank%20you%20anyway%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620724%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20will%20not%20sum%20a%20row%20of%20data%20drawn%20from%20a%20sheet%20in%20same%20workbook%20and%20returns%20zero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620724%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767668%22%20target%3D%22_blank%22%3E%40Hewtee%3C%2FA%3E%26nbsp%3BTexts%20formatted%20as%20numbers%20are%20still%20texts.%20The%20multiplication%20turned%20them%20into%20real%20numbers%20that%20can%20be%20summed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620895%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20will%20not%20sum%20a%20row%20of%20data%20drawn%20from%20a%20sheet%20in%20same%20workbook%20and%20returns%20zero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620895%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20Thanks%20for%20that%2C%20now%20I%20know%20what%20the%20x1%20does.%20Of%20course%20why%20it%20should%20be%20text%20without%20it%20I%20dont%20understand.%20But%20anyway%20thank%20you%20at%20least%20I%20now%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Adapt calc.PNG

 

 

@The formula in the yellow columns is =SUM(ADAPT[@[Owning Opportunities]:[Personal Leadership]])

 

5 Replies
Highlighted

@Hewtee Perhaps the numbers you are summing are in fact texts.

Highlighted

@Riny_van_Eekelen  Thanks. I checked the cells are formatted as numbers?  The formula inside each is =ALL!AL2

Highlighted
I just forunsd the answer I have to add *1 to the formula. Thank you anyway
Highlighted

@Hewtee Texts formatted as numbers are still texts. The multiplication turned them into real numbers that can be summed.

Highlighted
Best Response confirmed by Hewtee (Occasional Contributor)
Solution

@Riny_van_Eekelen  Thanks for that, now I know what the x1 does. Of course why it should be text without it I dont understand. But anyway thank you at least I now