• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Subtotal in Excel

April 9, 2021 by Andrew Childress
Column subtotals in Excel

Subtotals help you analyze subsets of data witch helps you see how items affect your overall data set. Here's how to add subtotals in Excel.

Subtotals help you analyze subsets of data. They help you see how specific items affect your overall data set. Let’s learn how to add subtotals in Microsoft Excel.

How to Add Subtotals in Excel

Imagine a list of data showing the most recent deals closed by your top salespeople. You could find a grand total by simply finding the sum of column B. But you might want to see the total for each salesperson. That’s where subtotals come in.

Subtotal Excel

The first rule of thumb for subtotals is that you need to sort your data by category. In this case, that’s by name. On the Home tab, click Sort & Filter, then choose Filter from the dropdown.

Subtotals in Excel

Then, click the dropdown arrow that appears inside cell A1. Click Sort: Ascending to group by name.

Now, it’s time to add your subtotals. With a cell in the range selected, on Excel‘s Data tab, click the Subtotal button in the Outline group.

How to subtotal in Excel

You’ll see the Subtotal menu appear. Here, you have a variety of options. At each change in: represents where subtotals will be inserted. Here, Excel automatically recognizes that you want to add subtotals by individual name.

  • Use function: demonstrates that subtotals don’t have to be totals. You can also use this feature to find averages, counts, and more.
  • Add subtotal to: lets you choose where you want the subtotal placed. This is most useful if you have multiple columns of numbers. Here, Sales is your value, so leave it set to the default.

How to find subtotals in Excel

Click OK, and you’ll see Excel insert subtotals for each salesperson’s total, along with a grand total at the bottom.

Column subtotals in Excel

As you can see, Excel makes adding subtotals easy. With smart features, you can use these with any numerical data set. This is a quick and easy way to analyze and compare categories of data.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:How to enable Excel macrosEnable Macros in Excel
Next Post:Unmerge Cells in ExcelUnmerge cells Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top