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