SUBTOTAL(function_num, ref1, ref2, ...) returns a subtotal : SUBTOTAL « Math Trigonometry functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Math Trigonometry functions
3. 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(1,A2:A5)

20.49.SUBTOTAL
	20.49.1.	SUBTOTAL(function_num, ref1, ref2, ...) returns a subtotal