You can also reference table data in formulas outside of the table area. For an unqualified reference there is no need to indicate the table name. Structured reference syntax rules.
The last formula that is set has priority between column and cell formulas.
SUM Formula for Excel Table. I have added 2 line items to the data now see the difference. You can add structured references to formulas in tables using the setColumnDataFormula and setColumnFormula methods. A circular reference is when a formula refers to itself.