| |
20.49.1.SUBTOTAL(function_num, ref1, ref2, ...) returns a subtotal |
|
function_num between 1 to 11 includes hidden values. |
function_num between 101 to 111 ignores hidden values). |
1/101 uses AVERAGE |
2/102 uses COUNT |
3/103 uses COUNTA |
4/104 uses MAX |
5/105 uses MIN |
6/106 uses PRODUCT |
7/107 uses STDEV |
8/108 uses STDEVP |
9/109 uses SUM |
10/110 uses VAR |
11/111 uses VARP |
Input the formula: =SUBTOTAL(9,A2:A5) |
![Input the formula: =SUBTOTAL(9,A2:A5)](../../Microsoft-Office-Excel-2007Images/Subtotalfunction_num_Ref1_Ref2__Returns_Subtotal___Input_Formula_subtotal9a2a5.PNG) |
Input the formula: =SUBTOTAL(1,A2:A5)
|
|
![Input the formula: =SUBTOTAL(1,A2:A5)](../../Microsoft-Office-Excel-2007Images/Subtotalfunction_num_Ref1_Ref2__Returns_Subtotal___Input_Formula_subtotal1a2a5.PNG) |
20.49.SUBTOTAL | | 20.49.1. | SUBTOTAL(function_num, ref1, ref2, ...) returns a subtotal | | ![SUBTOTAL(function_num, ref1, ref2, ...) returns a subtotal](../../Microsoft-Office-Excel-2007Images/Subtotalfunction_num_Ref1_Ref2__Returns_Subtotal___Input_Formula_subtotal9a2a5.PNG) |
|