Spread Formula Reference
SUBTOTAL
Formula Functions > Functions R to S > SUBTOTAL

This function calculates a subtotal of a list of numbers using a specified built-in function.

Syntax

SUBTOTAL(functioncode,value1,value2,...)

SUBTOTAL(functioncode,array)

Arguments

The functioncode argument is the number that represents the built-in function to use for the subtotal, as given in this table.

Built-In Function Function Code (Include Hidden Values) Function Code (Ignore Hidden Values)
AVERAGE 1 101
COUNT 2 102
COUNTA 3 103
MAX 4 104
MIN 5 105
PRODUCT 6 106
STDEV 7 107
STDEVP 8 108
SUM 9 109
VAR 10 110
VARP 11 111

Each additional argument can be a double-precision floating-point value, an integer value, or an array (cell range) of these. Up to 255 arguments can be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.

Remarks

The SUBTOTAL function does not include other SUBTOTAL formula results that are in the same range.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

SUBTOTAL(8,A1:B7)

Version Available

This function is available in product version 2.0 or later.

See Also

SUMPRODUCT | SUM | Math and Trigonometry Functions