SUBTOTAL function - Microsoft Support
It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it …
How to Use the SUBTOTAL Function in Excel (3 Methods)
Jul 22, 2024 · In this article, we showed how to use the Excel SUBTOTAL function. We used easier methods and included images to make them understandable.
Insert subtotals in a list of data in a worksheet - Microsoft Support
How to use the Subtotal command in Excel to calculate subtotals and grand totals in a list.
SUBTOTAL function in Excel - Step by Step Tutorial
Use the SUBTOTAL function in Excel (instead of SUM, COUNT, MAX, etc.) to ignore rows hidden by a filter or to ignore manually hidden rows.
How to Use the SUBTOTAL Function in Microsoft Excel
Nov 8, 2022 · Obtaining subtotals for groups of related items is easy in Microsoft Excel. In fact, you have two ways to do this. You can either use the SUBTOTAL function or the Subtotal feature, whichever …
6 Ways to Subtotal in Microsoft Excel
Dec 24, 2025 · Learn how to subtotal in Excel using simple methods ranging from manual Excel functions to Excel VBA-based automation. When you analyze a large dataset in Excel, you might …
How to Use the SUBTOTAL Function in Excel : 3 Methods
Jan 29, 2025 · Excel’s Subtotal feature is here to rescue you from endless scrolling and formula errors. This article shows you step-by-step how to use Subtotal in Excel to organize and analyze your data …
Excel SUBTOTAL function with formula examples - Ablebits
Mar 20, 2023 · The tutorial shows how to use the SUBTOTAL function to calculate data in visible cells – sum, count, average, find the minimum or maximum value, and more.
Excel SUBTOTAL function | Exceljet
Jan 3, 2023 · The Excel SUBTOTAL function is designed to run a given calculation on a range of cells while ignoring cells that should not be included. SUBTOTAL can return a SUM, AVERAGE, COUNT, …
How to Use the Subtotal Function in Excel: A Step-by-Step Guide
Jul 12, 2024 · Learn to harness Excel's Subtotal function with our step-by-step guide. Master data organization and analysis effortlessly. Perfect for beginners and pros alike!