How to Create Subtotal in Microsoft Excel (2026) | Step-by-Step
Learn how to create subtotal in Microsoft Excel using the built-in SUBTOTAL function and grouping tools. This tutorial walks you through exactly how to add subtotals to your data, whether you're working with sales reports, inventory lists, or financial summaries. You'll see how to use both the formula method and the Data tab subtotal feature so your totals update automatically as your data changes. This is the current, updated method that works in all modern versions of Excel including Microsoft 365. No prior experience needed — just follow along and you'll have subtotals set up in minutes. If this helped, subscribe for more Excel and productivity tutorials.