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.

How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.

Excel can automatically add SUBTOTAL functions for you. 1. The first option. Create a table and add a total row to the bottom of the table. Next, click any cell in the last row to automatically add a …

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

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 …

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: For each of …

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 …

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 can insert …

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 within your …