How to use the Subtotal command in Excel to calculate subtotals and grand totals in a list.

Aug 9, 2024 · In this article, we'll take a closer look at subtotals in Excel and how this feature makes it easier to compute totals, averages, counts etc.

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

Aug 4, 2025 · That’s where Excel’s **Subtotal feature** comes in handy. It automatically calculates subtotals for grouped data and even creates collapsible sections for easy …

Nov 8, 2022 · Once you have your subtotals, you can use the SUBTOTAL function once more for a grand total at the bottom. Alternatively, you can use the SUM function to add the subtotals.

May 28, 2025 · Learn how to use the SUBTOTAL () formula in Excel to create dynamic calculations that adjust to filtered data. Discover syntax, function numbers, and examples.

Jun 19, 2024 · Learn how to easily subtotal data in Excel with our step-by-step guide. Perfect for beginners looking to organize and analyze their spreadsheets efficiently.

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 …

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.