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)