Returns a subtotal in a list or database. It is generally easier to create a list with subtotals using the Subtotals command (Data menu). Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.

Syntax

SUBTOTAL(function_num,ref1,ref2,...)

## Function_num:
# is the number 1 to 11 that specifies which function to use in calculating subtotals within a list.

Function_Num | Function
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP


## Ref1, ref2,
# are 1 to 29 ranges or references for which you want the subtotal.

-------
Remarks

* If there are other subtotals within ref1, ref2,. (or nested subtotals), these nested subtotals are ignored to avoid double counting.
* SUBTOTAL will ignore any hidden rows that result from a list being filtered. This is important when you want to subtotal only the visible data that results from a list that you have filtered.
* If any of the references are 3-D references, SUBTOTAL returns the #VALUE! error value.

-------
Example

SUBTOTAL(9,C3:C5) will generate a subtotal of the cells C3:C5 using the SUM function

Suka dengan artikel ini? [Bagikan artikel ini ke teman2-mu di FACEBOOK. Klik disini]