SUBTOTAL Function Explained
The SUBTOTAL function in Microsoft Excel is used to calculate a subtotal of a given range of cells, using a specified function. It can be used to calculate the sum, average, count, maximum, minimum, etc. of the given range. It can also be used to ignore hidden rows or columns in the range.
SUBTOTAL Function Syntax
SUBTOTAL(function_num, ref1, [ref2], ...)
- function_num: A number 1-11 or 101-111 that specifies the function to use in calculating the subtotal.
- ref1: The first range or array argument for which you want to calculate a subtotal.
- ref2: [Optional] Additional ranges or arrays for which you want to calculate subtotals.