Returns a subtotal in a list or database.
Syntaxis
SUBTOTAL(function_num, ref1, …)Argumenten
function_numvereist
A number 1-11 or 101-111 that specifies which function to use for the subtotal.
ref1vereist
The range or reference to subtotal.
The SUBTOTAL function is unique because it can ignore hidden rows and nested subtotals. It uses a function number to determine which calculation to perform, such as SUM, AVERAGE, or COUNT.
=SUBTOTAL(9, A1:A10)→500Calculates the sum of cells A1 through A10, ignoring any other subtotals within that range.
Select the cell
Click the cell where you want the subtotal result to appear.
Enter the formula
Type =SUBTOTAL( followed by the function number and the range reference, then close with a parenthesis.
9 includes hidden rows in the calculation, while 109 ignores rows that are manually hidden.