Forum Discussion
Solved
Formula will not sum a row of data drawn from a sheet in same workbook and returns zero
@The formula in the yellow columns is =SUM(ADAPT[@[Owning Opportunities]:[Personal Leadership]])
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 🙂
Hewtee Perhaps the numbers you are summing are in fact texts.
I just forunsd the answer I have to add *1 to the formula. Thank you anyway 🙂
Hewtee Texts formatted as numbers are still texts. The multiplication turned them into real numbers that can be summed.
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 🙂