SUM function not working on cells with formula

SUM function not working on cells with formula

Hi,

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.

Dora

Best Answer

Answers

Sign In or Register to comment.