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

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

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 …

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.

1. Select the data. 2. Go to the Data tab > Filters. 3. Click on the filter icon on the data. 4. Write the SUBTOTAL function. Read more here.

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 …

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 …

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