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

1. For example, the SUM function below calculates the total sales. 2. Apply a filter. 3. The SUM function includes rows hidden by a filter. 4. The SUBTOTAL function ignores rows hidden by a …

Jul 22, 2024 · Let’s demonstrate how to use the SUBTOTAL function with a data set from two clothing store branches. Using the SUBTOTAL. Choose Subtotal from the Outline command. …

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 …

The SUBTOTAL function in Excel performs the arithmetic operations or basic Excel functions such as average, count, sum, max, min, product, etc. Primarily, the SUBTOTAL function is …

Jan 3, 2023 · SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, and others (see complete list below), and SUBTOTAL function can either include or exclude values in hidden …

May 28, 2025 · For example, SUBTOTAL(9, A2:A10) calculates the sum of A2:A10 including any manually hidden rows, while SUBTOTAL(109, A2:A10) excludes manually hidden rows from …

Apr 4, 2025 · This tutorial provides a comprehensive guide to using the SUBTOTAL function with detailed examples. You'll learn basic syntax, practical applications, and advanced techniques …

Feb 23, 2025 · Use the Excel SUBTOTAL function to summarize amounts, and exclude filtered or hidden rows. For Excel 2010 and later, the Excel AGGREGATE function is also available, and …

Nov 8, 2022 · As mentioned, SUBTOTAL in Excel allows you to group the same or related items in a list and use a function to calculate the values. For example, you can use it to sum sales by …