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)](http://www.java2s.com/Tutorial/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)](http://www.java2s.com/Tutorial/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](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Subtotalfunction_num_Ref1_Ref2__Returns_Subtotal___Input_Formula_subtotal9a2a5.PNG) |