Aug 29 2020 03:40 AM
@The formula in the yellow columns is =SUM(ADAPT[@[Owning Opportunities]:[Personal Leadership]])
Aug 29 2020 04:00 AM
@Hewtee Perhaps the numbers you are summing are in fact texts.
Aug 29 2020 06:58 AM
@Riny_van_Eekelen Thanks. I checked the cells are formatted as numbers? The formula inside each is =ALL!AL2
Aug 29 2020 07:02 AM
Aug 29 2020 07:10 AM
@Hewtee Texts formatted as numbers are still texts. The multiplication turned them into real numbers that can be summed.
Aug 29 2020 10:08 AM
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 :)
Aug 29 2020 10:08 AM
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 :)