Excel Function : SUBTOTAL
Category
Math and trigonometry
Description
Returns a subtotal in a list or database
Microsoft Excel Reference Page
https://support.office.com/en-us/article/SUBTOTAL-function-7b027003-f060-4ade-9040-e478765b9939
Syntax and Description of the SUBTOTAL Excel Function
The syntax for the SUBTOTAL excel function is as follows: =SUBTOTAL(function_num, ref1, [ref2], ...) The SUBTOTAL function has the following arguments: function_num - Required. A number 1 through 11 that specifies the type of summary function to use. - Required. A number 1 through 11 that specifies the type of summary function to use. ref1 - Required. The first reference or array for which you want a subtotal. - Required. The first reference or array for which you want a subtotal. ref2 - Optional. Additional references or arrays for which you want subtotals. Remarks
About SUBTOTAL Excel Function
The SUBTOTAL function in Excel calculates a subtotal in a list or database. The first argument is the function_num argument, which specifies which function to use to calculate the subtotal. The second argument is the ref argument, which is the range of cells to subtotal.
