Use the subtotal function in Excel to get totals of totals

Posted on:  08/18/2017
Use the subtotal function in Excel to get totals of totals

Excel’s SUBTOTAL function can show the SUM, AVERAGE, COUNT, MAX, MIN, and others functions. You should use the SUBTOTAL function to exclude values in hidden rows and get totals of totals.

YouTube Video of using Subtotals

Table of what the Subtotal numbers mean

Function number to include hidden values Function number to ignore hidden values Function
1 101 Average
2 102 Count
3 103 Counta
4 104 Max
5 105 Min
6 106 Product
7 107 Stdev
8 108 StDevp
9 109 Sum


Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 18 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at or watch his videos on YouTube at