Jul 22, 2024 · Choose Subtotal from the Outline command. Select the desired column from the dropdown. Choose the function you want to apply. Specify the columns where the function should …

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

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.

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 …

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.

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 …

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 …

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 …

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 …

In this article, we will learn How to use the SUBTOTAL function in Excel. Obtain results on filtered rows. The biggest problem with SUM, AVERAGE, COUNT and other NUMBER functions is, that they …