So, I’m trying to make a cell that can sum a column. But i’m writing it in a Data Table and then putting in the Excel File. Is there a way to do this? Or I’ll need to write it in Excel directly?

Example:

So, I’m trying to make a cell that can sum a column. But i’m writing it in a Data Table and then putting in the Excel File. Is there a way to do this? Or I’ll need to write it in Excel directly?

Example:

Hi welcome to the community!

I hoping you mean excel FORMULA, if so, just use:

`row("Column") = "=SUM(C2:C4)"`

Yea, that’s what i meant, sorry.

But it’s not working here. It just gave me the exact formula in the space, not the result of it.

Is the column formatted as “text” in the Excel sheet? If that is the case, then this might work: