How to Create Automatic Subtotals in Excel | Nested (Multiple) Subtotals | Group Rows & Subtotal

In this video tutorial I explain how to quickly and easily group rows and create automatic subtotals. I also demonstrate how to create nested subtotals based on grouping in multiple columns.

Table of Contents:

00:00 - Introduction
00:04 - Group and create subtotals for one column
01:11 - Group and create nested subtotals for multiple columns
------------------------

[IvanCortinas_ES]

Thank you Chester. Great explanation about Subtotal!!

[blueridgemountainsmedia]

Thank you Chester! Just what I needed to get ready to submit my taxes.

[TylehurstXL]

Nice tutorial, interesting but never needed it over pivot table option. But yes, having this mixed with linked to cell image and vba would look quite slick I suppose

[sophielallemand]

So great thank you ! Anyone knows if this is feasible in Google Sheet as well ?

[mdmilonmahamud]

Which should I learn, VBA or Python or Javascript?

[uhpandya]

How to remove zero value from the subtotal