1. Computing

Inserting Subtotals and Totals into a Database

By , About.com Guide

1 of 4

Excel SUBTOTAL Feature Overview
Excel 2007 Subtotal Feature

Excel 2007 Subtotal Feature

© Ted French

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 can 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

©2013 About.com. All rights reserved.