To include structured references in your formula, select the table cells you want to reference instead of typing their cell reference in the formula. Let's use the following example data to …

If an array or reference argument contains text or empty cells, those values are ignored. If the specified range contains no logical values, the AND function returns the #VALUE! error.

This is called a structured reference formula, which is unique to Excel tables. The structured reference format is what allows the table to use the same formula for each row.

When you use explicit cell references like this (where you reference each cell individually, separated by a comma) and delete a referenced row or column, Excel can't resolve it, so it …

Les références structurées facilitent l’utilisation de formules avec des tableaux Excel en remplaçant les références de cellule comme C2:C7 par des noms prédéfinis pour les éléments …

当您的 Excel 表格之外创建一个引用表格数据的公式时，也会显示结构化引用。 引用可更易于在大型工作簿中定位表格。 若要在公式中包含结构化引用，请选择要引用的表单元格，而不是在 …

If you are writing a dynamic array formula to act on a list of data, it can be useful to place it in an Excel table, then use structured references to refer to the data.

Excel names the cells based on the labels in the range you designated. Use names in formulas Select a cell and enter a formula. Place the cursor where you want to use the name in that …

Any structured references (references that use table names) that were used in formulas turn into regular cell references.

Learn more about Using structured references with Excel tables. You can also apply a different function to the total value, by selecting the More Functions option, or writing your own.