A syntax used in Excel tables that refers to table data by name rather than cell coordinates.
Wypróbuj z SIStructured 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.