Excel 2007 Subtotal Function Tutorial
Return to Excel Subtotal Tutorial List.
Excel's Subtotal feature works by inserting the SUBTOTAL function into a database or a list of related data. Using the Subtotal feature makes finding and extracting specific information from a large table of data quick and easy.
Even though it is called the "Subtotal feature", you are not limited to finding the sum or total for selected rows of data. In addition to the total, you can also find the smallest or lowest values for each subsection of a database.
This step by step tutorial includes an example of how to find the lowest number of sales orders for each sales region.
The steps in this tutorial are: