How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.| support.microsoft.com
Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.| support.microsoft.com