| Microsoft Office Excel 2007 Tutorial » Math Trigonometry functions » SUBTOTAL |
| 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) | |
 | |
| |
 |
| 20.49.SUBTOTAL | ||||
| 20.49.1. | SUBTOTAL(function_num, ref1, ref2, ...) returns a subtotal | | ||