Loading…
Loading…
An Excel Table turns a plain range into a named object that grows by itself. Click inside your data and press Ctrl+T (in this browser use Ctrl+L, which Excel also accepts, because the browser keeps Ctrl+T for new tabs). Formulas can then use structured references: Sales[Units] is the whole Units column, and [@Price] is the Price on the same row. Type a new row under the table and every formula that uses it updates. No range to stretch.
Syntax
=SUM(Sales[Units]) · =[@Units]*[@Price] · =SUMIFS(Sales[Units], Sales[Region], "North")
Example: Type =[@Units]*[@Price] in the first row of a new column and Excel fills the whole column (a calculated column). Turn on Total Row to get a SUBTOTAL that ignores filtered-out rows.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.