About 246,000 results
Open links in new tab
  1. SUBTOTAL function - Microsoft Support

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

  2. SUBTOTAL function in Excel - Step by Step Tutorial

    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.

  3. Excel SUBTOTAL function | Exceljet

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

  4. How to Use the SUBTOTAL Function in Excel : 3 Methods

    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 …

  5. Excel SUBTOTAL function with formula examples - Ablebits

    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.

  6. How to Use the Subtotal Function in Excel: Step-By-Step

    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.

  7. 6 Ways to Subtotal in Microsoft Excel

    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 …

  8. SUBTOTAL() Formula in Excel: A Full Calculation Guide

    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.

  9. MS Excel: How to use the SUBTOTAL Function (WS) - TechOnTheNet

    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 …

  10. SUBTOTAL Function In Excel - Formula, Examples. How to Use?

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