Parameter List
Syntax
SUBTOTAL(function_code, range1)
function_code
The code of the function to execute. Use 1 for AVERAGE, 2 for COUNT, 3 for COUNTA, 4 for MAX, 5 for MIN, 6 for PRODUCT, 7 for STDEV, 8 for STDEVP, 9 for SUM, 10 for VAR_S, and 11 for VAR_P.
range1
Values to which apply the function.