To add subtotals in a table, you must first convert the table to a normal range of data, and then add the subtotal. Note that this will remove all table functionality from the data except table formatting.

On the Data tab, in the Outline group, click Subtotal to outline your data. Explanation: in this example, Excel automatically added 5 SUBTOTAL functions (B6, B9, B13, B19 and B20).

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.

Dec 24, 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 Excel tutorial …

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 the Subtotal …

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 month or …

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!

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 subtotal details, copy …

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 can modify it …

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 …