SUBTOTAL
Category: Mathematical Function.
Description: Performs a specified calculation (the sum, product, average, etc.) for a supplied set of values.
Syntax: SUBTOTAL(function_num, ref1, ref2, …)
Refer to the SUBTOTAL specifics endnote.
The function_num argument is a number that specifies the calculation type.
Possible values for the function_num argument are listed in the following table.
Note that by selecting a proper function_num argument you can ignore or include hidden values in calculation.
|
Function_num (include hidden values)
|
Function_num (ignore hidden values)
|
Function
|
|
1
|
101
|
AVERAGE
|
|
2
|
102
|
COUNT
|
|
3
|
103
|
COUNTA
|
|
4
|
104
|
MAX
|
|
5
|
105
|
MIN
|
|
6
|
106
|
PRODUCT
|
|
7
|
107
|
STDEV
|
|
8
|
108
|
STDEVP
|
|
9
|
109
|
SUM
|
|
10
|
110
|
VAR
|
|
11
|
111
|
VARP
|