Excel Subtotal Tutorials

Not only can you find Subtotals and totals with the Subtotal feature but you can also find average values, max and min values, and count up the number of rows of data included in the range. These tutorials include step by step examples.

Inserting Subtotals and Totals into a Database
Excel's Subtotal feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes an example of how to insert subtotals and totals into a database.

Find the Largest Values with Excel's Subtotal Feature
Excel's Subtotal feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes an example of how to use Excel's Subtotal feature to find the largest values in subsections of a database.

Find Average Values with Excel's Subtotal Feature
Excel's SUBTOTAL feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes examples of how to find an average value for your data using the Excel SUBTOTAL feature.

Find the Smallest Values with Excel's Subtotal Feature
Excel's Subtotal feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes an example of how to use Excel's Subtotal feature to find the smallest values in subsections of a database.

Data for Excel SubTotal Tutorial
This document contains pivot table data for the Excel subtotal tutorial. The subtotal tutorial data is to be copied and pasted into the tutorial worksheet.

Discuss in my forum

Spreadsheets