It calculates the Sum of the specified range. It calculates Standard Deviation based on the entire population. It estimates Standard Deviation in the specified range.

It calculates the product of cells in the specified range. It will find out the smallest value in the specified range. It will find out the largest value in the specified range. It will Counts non-empty cells in the specified range. It will Count the number of cells that contain numeric values. It calculates the Average of a specified range. It will find values only invisible rows that ignore hidden values in the calculation. Ignore hidden values When the function_num argument is between 101-111, the SUBTOTAL function will exclude or ignore the hidden values.Include hidden values When the function_num argument is between 1-11, the SUBTOTAL function will include the hidden values.It is a type of mathematical operation that you like to perform.Ī function_num argument is applied based on the below mentioned two criteria or methods. SUBTOTAL(function_num, ref1, ,…)Whereįunction_num or operation code: It indicates which function should be used to calculate the subtotals within a given list. The formula for the SUBTOTAL function is as follows: It performs a specified calculation for a given set of values. Returns a subtotal in a database or list, i.e., finding out the subtotal of a given range of cells.

Excel functions, formula, charts, formatting creating excel dashboard & others