SUBTOTAL function - Microsoft Support
How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.
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.
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 …
How to Use the SUBTOTAL Function in Microsoft Excel
Nov 8, 2022 · To use the SUBTOTAL function, create a formula using the syntax: SUBTOTAL (function_number, reference 1, reference 2,...). You can also use the Subtotal feature by …
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.
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!
6 Ways to Subtotal in Microsoft Excel
Sep 22, 2025 · In Microsoft Excel, a subtotal analysis might include different statistical functions, like average, sum, counts, max, min, standard deviation, and more. Follow along with this …
Subtotals in Excel: how to insert, use and remove - Ablebits
Mar 20, 2023 · The tutorial explains how to use the Excel Subtotal feature to automatically sum, count or average different groups of cells. You will also learn how to display or hide the …
How to Use the SUBTOTAL Function in Excel - CareerFoundry
Aug 31, 2023 · The SUBTOTAL function in Microsoft Excel returns the subtotal value from a range of cells. Learn how to use it in this step-by-step tutorial.