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

[Hewtee]

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

[#2]

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

[#3]

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

[#4]

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

[#5]

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

[#6 · Accepted 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 :)