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

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.

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 …

Jan 3, 2023 · Excel has a Subtotal feature that automatically inserts SUBTOTAL formulas in sorted data. You can find this feature at Data > Outline > Subtotal. SUBTOTAL formulas inserted this way use the …

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 …

May 28, 2025 · What Is the SUBTOTAL () Function in Excel? The SUBTOTAL() function calculates aggregate values such as sum, average, count, and other statistical operations on a dataset. What …

What Is SUBTOTAL function In Excel? The SUBTOTAL function in Excel performs the arithmetic operations or basic Excel functions such as average, count, sum, max, min, product, etc. Primarily, …

Mar 20, 2023 · The tutorial explains the specificities of the SUBTOTAL function in Excel and shows how to use Subtotal formulas to summarize data in visible cells. In the previous article, we discussed 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: For each of …