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.

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

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.

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

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.

It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUBTOTAL function can be entered as part of a formula in a cell of a worksheet. The syntax for the SUBTOTAL function …

In cells C12 and C13 of the spreadsheet below, the Subtotal function is used to calculate the sum and the average monthly sales per team. As all of the cells in the range of sales figures are visible, the …