How to Use Subtotal in Excel – Tutorial

We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)

Excel tutorial on how to use Subtotal in Excel. We’ll use the Subtotal button, found in the Data tab, and then go over how to use the SUBTOTAL function.

The SUBTOTAL function in Excel is made up of 2 things: a math calculation (in the form of a function) and the data to be subtotaled. With 11 calculations to choose from to subtotal data, using the SUBTOTAL function is an easy way to summarize data so that it can be easier to understand.