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

Inserting Subtotals and Totals into a Database

By

2 of 4

Enter the Subtotal Tutorial Data
Enter the Subtotal Tutorial Data

Enter the Subtotal Tutorial Data

© Ted French

Enter the Subtotal Tutorial Data

The first step to using the Subtotal feature in Excel is to enter the data into the worksheet.

When doing so, keep the following points in mind:

  • It is important to enter data correctly. Errors, caused by incorrect data entry, are the source of many problems related to data management.

  • Leave no blank rows or columns when entering the data. This includes NOT leaving a blank row between the column headings and the first row of data.

Tutorial Steps

Enter the data into cells A1 to D12 as seen in the image above. For those who do not feel like typing, the data and instructions for copying it into Excel, are available at this link.

©2014 About.com. All rights reserved.