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.

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

Jan 3, 2023 · The Excel SUBTOTAL function is designed to run a given calculation on a range of cells while ignoring cells that should not be included. SUBTOTAL can return a SUM, …

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 …

Aug 4, 2025 · When working with **large datasets**, manually calculating totals for each group can be tedious. That’s where Excel’s **Subtotal feature** comes in handy. It automatically …

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

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

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 …