Formulas with structured references do not operate with cells or range references, but with the names of the table and columns of the table, as well as the names of table areas.

The examples of regular and structured references:

Description	Regular reference	Structured reference
Reference to cell range of the Sales column in Table1	=MAX(B2:B8)	=MAX(Table1[Sales])
Reference to the data area in Table2	=MAX(A2:C8)	=MAX(Table2[#Data])

references_2

Structured references can be used both in the table and outside of it.

If a formula with a structured reference is located directly in a table, it is not necessary to specify the table name in this reference. If a table name is specified in a reference for any reason, it is automatically removed when you enter a formula. For example, the formula =MAX(Table1[Sales]) will be automatically replaced with =MAX([Sales]).

If a formula with a structured reference is located outside the table, the name of the table must be specified.

Was this helpful?

Yes