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
Excel can automatically add SUBTOTAL functions for you. 1. The first option. Create a table and add a total row to the bottom of the table. Next, click any cell in the last row to automatically …
How to Use the SUBTOTAL Function in Microsoft Excel
Nov 8, 2022 · As mentioned, SUBTOTAL in Excel allows you to group the same or related items in a list and use a function to calculate the values. For example, you can use it to sum sales by …
6 Ways to Subtotal in Microsoft Excel
Sep 22, 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 …
Excel SUBTOTAL function | Exceljet
Jan 3, 2023 · Excel has a Subtotal feature that automatically inserts SUBTOTAL formulas in sorted data. You can find this feature at Data > Outline > Subtotal. SUBTOTAL formulas …
SUBTOTAL() Formula in Excel: A Full Calculation Guide
May 28, 2025 · When you apply a filter to your data or manually hide certain rows, SUBTOTAL() automatically adjusts its calculation to include only the visible cells. This behavior makes it an …