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.

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 …

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.

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 …

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.

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!

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 …

Aug 4, 2025 · Excel subtotals allow you to: 1. Sort Your Data. For subtotals to work properly, **sort your data** by the column you want to group (e.g., by “Category” or “Region”). 2. Use …

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 …