Pinterest Pixel

Excel’s Subtotal Feature

Excel´s Subtotal feature is a great way to automatically insert a Sum/Count/Average/Max/Min subtotal to your data set with a... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Excel's Subtotal Feature | MyExcelOnline Excel's Subtotal Feature | MyExcelOnline

Excel´s Subtotal feature is a great way to automatically insert a Sum/Count/Average/Max/Min subtotal to your data set with a press of a button.

This feature is located under the Excel Data tools menu: Data > Subtotal.  To insert this feature you need to follow these quick steps:

STEP 1: Highlight your data and go to Data > Subtotal

Excel's Subtotal Feature

STEP 2: This will open up the Subtotal dialogue box

Excel's Subtotal Feature

STEP 3: At each change: Select which column you want to use to separate the data.  Make sure that the data in the selected column is in ascending/descending order

Excel's Subtotal Feature

STEP 4: Use function: Select which function you want to use for your calculation.  You can select from Sum, Count, Average, Maximum, Minimum, Product, Count Numbers, StdDev, StdDevp, Var, Varp

Excel's Subtotal Feature

STEP 5: Add subtotal to: Select the column that you want to Subtotal

Excel's Subtotal Feature

STEP 6: Press OK and this will add extra lines to your data with the chosen Subtotal

See also  Extract Numbers Using Flash Fill In Excel

Excel's Subtotal Feature

STEP 7: If you want to change the Subtotal (say from a Sum to an Average) all you have to do is click in your data and go to Data > Subtotal and it will bring up the Subtotal dialogue box once again.  Under Use function select Average and press OK.

Excel's Subtotal Feature

Excel's Subtotal Feature | MyExcelOnline
Download workbookSubtotals-Feature.xlsx

 

Excel Pivot Table

 

If you like this Excel tip, please share it
Excel's Subtotal Feature | MyExcelOnline Excel's Subtotal Feature | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...