Subtotal by Name

An Excel file that teaches how to perform Subtotal by Name operation.

Excel Professional Subtotal By Name

Data is first sorted by island. The SUBTOTAL function is applied based on ranges. Group transitions are determined by formula. Values are aggregated in the summary table. Calculations remain accurate when filters are active.

Hope it is useful.