Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Math Trigonometry Functions

 

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(1,A2:A5)