SUM function not working on cells with formula
I faced an issue with the SUM function, since it seems to not work on a column in which the cells contain a formula to return a number.
The cells that i want to SUM contain (JOIN(COLLECT)) formulas that pull data from another sheet. When I insert =SUM([Total Price]1:[Total Price]70) the SUM just returns 0. Also if I highlight the column by clicking on the header the SUM is not showing up in lower right corner as it does otherwise. The type of the column is Text/Number.
What am I missing for the SUM to work properly?
Thank you for any advice in advance.