It offers 11 Excel functions that can be executed by specifying the corresponding argument. Syntax SUBTOTAL(function_num,ref1,[ref2],…) ArgumentRequired/OptionalExplanation function_num Required This number ranges from 1 to 11 or 101 to 111, specifies which function the SUBTOTAL will use. ...
You can also apply other functions by clicking on More Functions. Select Sum for the cells C14 and D14 to get the total values. Read More: How to Insert Row Below in Excel Method 2 – Insert a Total Row by Keyboard Shortcut Steps: Create a table following the steps of Method 1. Sel...
Function_numRequired. The number 1-11 or 101-111 that specifies the function to use for the subtotal. 1-11 includes manually-hidden rows, while 101-111 excludes them; filtered-out cells are always excluded. Function_num (includes hidden rows) ...
We all have used the contemporary functions of Excel – the SUM Function, the AVERAGE function, the COUNT function, and so on But today, we are going to introduce you to such a versatile function of Excel that will knock your socks off. This one function can perform all these functions. ...
Here steps in the SUBTOTAL function of Excel.SUBTOTAL Function Syntax :=SUBTOTAL(function_number, ref1, [ref2]...)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....
Example of Subtotal Function in Excel: In the below example I have used multiple subtotal functions. The formula =SUBTOTAL(9,B2:B11) results into the Sum (operation code = 9) of all the elements present in the range B2:B11. And =SUBTOTAL(1,B2:B11) results into the Average (operat...
In the below-mentioned example, multiple subtotal functions are applied. In a cell, C14, C15 & C16 SUBTOTAL function is applied. To calculate the SUM value, Function number 9 or 109 is used in a subtotal function where It calculates the Sum of a specified range, i.e. =SUBTOTAL (9,...
The number 1-11 or 101-111 that specifies the function to use for the subtotal. 1-11 includes manually-hidden rows 101-111 excludes them Filtered-out cells are always excluded. Look at the Function_num Table below to know the Functions. Required Ref1 The first named range or reference fo...
Explanation: the first cell ($B$2) in the range reference is anabsolute reference. We locked the reference to cell B2 by adding a $ symbol in front of the column letter and row number. The second cell (B2) in the range reference is a normalrelative reference. ...
The Excel Subtotal feature inserts formulas with function number 1-11. In the above example, inserting subtotals with the Sum function creates this formula:SUBTOTAL(9, C2:C5). Where 9 represents the SUM function, and C2:C5 is the first group of cells to subtotal. ...