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

Jul 22, 2024 · In this section, we’ll demonstrate how to perform the count operation using the SUBTOTAL function in Excel. The SUBTOTAL function allows us to display both the COUNT and …

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.

Dec 24, 2025 · When you analyze a large dataset in Excel, you might want to group relevant data and create intermediate totals before the grand total. This is commonly known as subtotal. It’s one of the …

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

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.

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 list or …

You now know when to use simple functions and when to play around with a more versatile – SUBTOTAL function 🎭 With that, let’s look into some more examples of the SUBTOTAL function to …

Mar 20, 2023 · The tutorial shows how to use the SUBTOTAL function to calculate data in visible cells – sum, count, average, find the minimum or maximum value, and more.

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