What does this function do?
Returns a subtotal in a list or database.
Syntax:
SUBTOTAL(function_num, ref1, ref2, ...)
- function_num (required): is the number 1 to 11 (includes hidden values) or 101 to 111 (ignores hidden values) that specifies which function to use in calculating subtotals within a list.
- ref1 (required): first range or reference for which you want the subtotal.
- ref2 (required): are 2 to 254 ranges or references for which you want the subtotal.
Function_num
(includes hidden values) |
Function_num
(ignores 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
|
Examples:
If A1:A5 = {1,3,5,7,15}=SUBTOTAL(1,A1:A5) = Average range A1:A5 = 6.2
=SUBTOTAL(9, A1:A5) = Sum of the range A1:A5 = 31
No comments:
Post a Comment