How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.

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.

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.

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 …

What Is SUBTOTAL function In Excel? The SUBTOTAL function in Excel performs the arithmetic operations or basic Excel functions such as average, count, sum, max, min, product, etc. …

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.

In this article, we will learn How to use the SUBTOTAL function in Excel. Obtain results on filtered rows. The biggest problem with SUM, AVERAGE, COUNT and other NUMBER functions is, …

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 …

Here’s the syntax of this function 🔍. =SUBTOTAL (function_num, ref1, ref2 … The function_num tells SUBTOTAL which function is to be performed. Here’s the list of options available to you: …

Instead of applying multiple formulas to sum up or average these figures, the Subtotal function is your go-to tool. It deftly calculates everything from sums to averages, counts to max values, all …