1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Find Average Values with Excel's Subtotal Feature


1 of 4

Excel SUBTOTAL Feature Overview
Find Averages with Excel's Subtotal Feature

Find Averages with Excel's Subtotal Feature

© Ted French

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:

  1. Enter the Tutorial Data

  2. Sorting the Data Sample

  3. Finding the Average Value

©2014 About.com. All rights reserved.