Find Average Values with Excel 's Subtotal Feature
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 average values for each column or field of data in your database.
This step by step tutorial includes an example of how to find average values for a specific column of data in a database.
The steps in this tutorial are: