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.

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 …

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 …

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 …

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!

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: …

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 …

How To Use SUBTOTAL () In Excel? The SUBTOTAL function performs a specific calculation on numeric values when we insert the function number according to the function_num list. We …

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, …