Adding Subtotals - Excel
Overview
¶
This article outlines how to add subtotals to a rectangular range of data in an Excel spreadsheet
Procedure
¶
Make sure your range of data is rectangular and has a heading for every column
Select any cell in your range of data
Sort your range by the column you want to group by
Data tab > Outline group > Subtotal