SUBTOTAL function - Microsoft Support
How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.
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 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 …
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, …
6 Ways to Subtotal in Microsoft Excel
Sep 22, 2025 · When you analyze a large dataset in Excel, you might want to group relevant data and create intermediate totals before the grand total. This is commonly known as subtotal. It’s …
How to Use the Subtotal Function in Excel: Step-By-Step
1. Select the data. 2. Go to the Data tab > Filters. 3. Click on the filter icon on the data. 4. Write the SUBTOTAL function. Read more here.
SUBTOTAL() Formula in Excel: A Full Calculation Guide
May 28, 2025 · Learn how to use the SUBTOTAL () formula in Excel to create dynamic calculations that adjust to filtered data. Discover syntax, function numbers, and examples.