Structured references

A structured reference designates part of a structured table by its name rather than by a cell address. It is written with the table name and the column name in square brackets, and adjusts automatically as the table grows. It makes formulas more readable and more robust.

Example

=SOMME(Ventes[Montant])

Related concepts

The whole glossary