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

May 28, 2025 · Learn how to use the SUBTOTAL () formula in Excel to create dynamic calculations that adjust to filtered data. Discover syntax, function numbers, and examples.

Guide to SUBTOTAL Function in Excel. Here we will use the function with different arithmetic formulas, examples & downloadable Excel template.

Sep 22, 2025 · In Microsoft Excel, a subtotal analysis might include different statistical functions, like average, sum, counts, max, min, standard deviation, and more. Follow along with this …

This Excel tutorial explains how to use the Excel SUBTOTAL function with syntax and examples. The Microsoft Excel SUBTOTAL function returns the subtotal of the numbers in a column in a …

Instead of applying multiple formulas to sum up or average these figures, the Subtotal function is your go-to tool. It deftly calculates everything from sums to averages, counts to max values, all …

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