You can automatically calculate subtotals and grand totals in a list for a column by using the Subtotal command. Important: Subtotals are not supported in Excel tables. The Subtotal …

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.

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

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).

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 …

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

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 …

Jul 15, 2024 · In the "Data" tab, find and click on the "Subtotal" button. This button opens up a dialog box where you can set the parameters for your subtotal calculation. It’s pretty …

Nov 13, 2023 · Instead of taking just the filtered cells, the SUM function has taken all the cells between the first and last filtered cells. The formula has summed up the range H6:H17 which …

As a function, it is able to insert subtotal into different groups of data. As a formula, it can help you derive subtotal in filtered records. Subtotal formula works within a cell while the other works …