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

STEP 2: This will open up the Subtotal dialogue box

2015-11-05_14-25-46

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

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

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

Excel's Subtotal Feature | MyExcelOnline

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

Excel's Subtotal Feature | MyExcelOnline

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

Excel's Subtotal Feature | MyExcelOnline
DOWNLOAD WORKBOOK

 

HELPFUL RESOURCE:

Excel Pivot Table

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Excel's Subtotal Feature | MyExcelOnline