Syntax SUBTOTAL (function_num,ref1, [ref2],...) The SUBTOTAL function syntax has the following arguments: Function_num Required. The number 1-11 or 101-111 that specifies the …

Jul 22, 2024 · The SUBTOTAL function returns a list or database and falls under the Math/Trig function category. It offers 11 Excel functions that can be executed by specifying the …

To use the SUBTOTAL function, create a formula using the syntax: SUBTOTAL (function_number, reference 1, reference 2,...). You can also use the Subtotal feature by …

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.

function_num - A number that specifies which function to use in calculating subtotals within a list. See table below for full list. ref1 - A named range or reference to subtotal. ref2 - [optional] A …

Mar 20, 2023 · Function_num - a number that specifies which function to use for the subtotal. Ref1, Ref2, … - one or more cells or ranges to subtotal. The first ref argument is required, …

Aug 9, 2024 · The Subtotal feature in Excel offers the following options: At each change in: In the At each change in box, choose a column to group by. Use function: In the Use function box, …

Jul 27, 2024 · To use a different function with SUBTOTAL, enter the corresponding number from the list provided above. Read More: How to Insert Subtotals in Excel. Select anywhere in the …

Function_number: Subtotal supports various number functions. To easily access them, it uses a function number. Below is the table of function number with corresponding functions.

Jan 29, 2017 · There are 11 different operations you can use with the SUBTOTAL function. They are numbered by values from 1 to 11. You can use each of those functions types in two …