How to use the Subtotal Feature and the SUBTOTAL Function in Excel




About this tutorial:

Video duration: 00:08:08
In this video, discover the difference between the SUBTOTAL function and the Subtotal feature in Excel and learn how to use both to insert subtotals in your data.

Here is a link to the blog post where you can download the example Excel file I use in the video:

The Subtotal feature adds subtotal and grand total rows to a data set to convert data to a summary report. It also adds row groups that can be expanded and collapsed to just view the subtotal rows.

The SUBTOTAL function is used within the subtotal rows that are…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads