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 🙂
5 Replies
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. I checked the cells are formatted as numbers? The formula inside each is =ALL!AL2
