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

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.

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.

Thank you! 👍👍 In this Microsoft Excel video tutorial I explain how to use Excel's SUBTOTAL function.

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

Mar 20, 2023 · As soon as you start typing a Subtotal formula in a cell or in the formula bar, Microsoft Excel will display a list of available function numbers for you. For example, this is how you can make …

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

Jul 22, 2025 · The SUBTOTAL function in Excel uses a function number (e.g., 9) to specify the type of calculation. The number 9 corresponds to a sum of visible cells only, ignoring hidden rows (e.g., …

As you start writing the SUBTOTAL function, a list of function_num options appears. Select the option for SUM i.e. 9. To choose SUM, we have selected 9 and not 109. This is because we want to sum …