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.

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

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 …

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

May 28, 2025 · The SUBTOTAL() function calculates aggregate values such as sum, average, count, and other statistical operations on a dataset. What makes it different from standard …

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

Jan 29, 2025 · Excel’s Subtotal feature is here to rescue you from endless scrolling and formula errors. This article shows you step-by-step how to use Subtotal in Excel to organize and …

Feb 23, 2025 · Use the SUBTOTAL function to exclude filtered or hidden rows when calculating a total on the worksheet. You can choose any one of the 11 functions that SUBTOTAL can …