Inserting Subtotals and Totals into a Database

Inserting Subtotals and Totals into a Database

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.

The Subtotal feature has been developed to make it easy to extract specific information from rows of related data. You are not, however, limited to finding just subtotals as the name suggests. You have eleven different options for the type of information you find.

Finding subtotals is one of those eleven options, however, and this step by step tutorial covers how to find subtotals 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. Inserting Subtotals and Totals into a Database

• Excel SUBTOTAL Feature Overview
• Enter the Subtotal Tutorial Data
• Sorting the Data
• Inserting Subtotals and Totals into a Database