Produce Subtotals for your data

Here are the steps to follow in this lesson:

  1. Sort your data according to the field (column) by which you wish to group your records.
  2. From the DATA menu select SUBTOTALS.
  3. In the Subtotals dialog box confirm the correct field and select the FUNCTION you wish to use. There are 11 possible functions (including SUM, AVERAGE, MIN, MAX)
  4. Check to FIELDS that you want to be subtotaled and then click OK.
  5. Excel automatically OUTLINES your data. Click the Expand and Collapse buttons on the outline to see more or less detail. Click the Outline Levels to see different views of your subtotals.
  6. Explore the other options in the Subtotal dialog box (First choose Data – Subtotals.)
  7. You can remove ALL Subtotals in the Subtotal dialog box.

NEW! Download the Excel Practice file that I use in this video:

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Speak Your Mind