A syntax used in Excel tables that refers to table data by name rather than cell coordinates.
AI で試すStructured references allow formulas to automatically adjust when data is added or removed from a table. By using descriptive names like 'Table1[Sales]' instead of 'A2:A10', formulas become more readable and less prone to errors when the table structure changes.
=SUM(Table1[ColumnName])Instead of =SUM(B2:B10), you use =SUM(SalesTable[Amount]) to calculate the total of the Amount column in SalesTable.
They make formulas easier to read and automatically expand as you add new rows to your table.