Tame Your Data. Master Your Reports.

Excel’s Subtotal feature is one of the fastest ways to summarize and organize large lists—but most people barely scratch the surface of what it can do. If you’ve ever fought with grouping, struggled to format totals, or wished your reports could be cleaner, faster, and smarter, this book shows you how to make Subtotals work for you.

In Excel Subtotals: Straight to the Point, Excel expert Bill Jelen (a.k.a. MrExcel) walks you through dozens of real-world tips, tricks, and problem-solvers. From simple “add a total at the bottom” tasks to advanced subtotaling strategies with formulas, custom sorting, VBA, and Power Query, you’ll learn how to get exactly the results you need—without wasting time.

Inside, you’ll discover how to:

Set up data for flawless subtotaling

Sort by days of the week or custom sequences

Add text, formatting, or calculations to subtotal rows

Subtotal one column while counting another

Insert page breaks, blank lines, and shifted totals automatically

Use SUBTOTAL and AGGREGATE functions for filtered data

Create horizontal subtotals and work around “Tables don’t subtotal”

Automate subtotaling with VBA or replace it entirely with Power Query

Whether you’re building reports for your boss, preparing data for analysis, or just trying to wrangle huge spreadsheets, this book gives you the straight-to-the-point techniques to subtotal like a pro.

Stop scrolling for answers—make Excel total it up for you.