The subtotal feature in Excel allows you to generate summary information, such as subtotals, averages, record counts, and maximum and minimum values for groups of records in a database. When you generate the summary information, Excel adds summary and grand total rows to the worksheet, labels each row, and outlines the records in each group. By clicking on the outline minus and plus symbols, you can quickly hide and show the details for each summarized group of data. The subtotal feature also allows you to remove and replace summary information.
The Subtotal Button for Summarizing Data in an Excel Database (740.9 KiB, 2,569 hits)