Would an Excel table help stop new equipment rows being left out of our total?
TechnologyOur equipment total still uses `SUM(C2:C10)`. A helper added another item in row eleven, copied the formatting and assumed the total would include it. The formula still ends at row ten.
Microsoft describes structured references that use an Excel table's column names and adjust as data is added to or removed from that table. Excel's structured-reference guidance
Would you use a table for a list that keeps growing, or keep extending the range manually? I want the next helper to understand which rows are included, rather than rely on a copied colour making the new item look like part of the calculation.