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 …

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

Jan 29, 2025 · Excel’s Subtotal feature is here to rescue you from endless scrolling and formula errors. This article shows you step-by-step how to use Subtotal in Excel to organize and …

Nov 8, 2022 · Obtaining subtotals for groups of related items is easy in Microsoft Excel. In fact, you have two ways to do this. You can either use the SUBTOTAL function or the Subtotal …

Mar 20, 2023 · See to use Excel Subtotal feature to automatically sum, count or average groups of cells. Learn how to insert multiple subtotals, copy only subtotals, display or hide subtotal …

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 …

Jul 12, 2024 · If you want to quickly sum up data in Excel, the Subtotal function is your go-to tool. You can apply it to calculate sums, averages, counts, and more based on different groups …

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

As a worksheet function, the SUBTOTAL function can be entered as part of a formula in a cell of a worksheet. The syntax for the SUBTOTAL function in Microsoft Excel is: