Returns the subtotal of the specified arguments.

Syntax  Copy Code
SUBTOTAL( Integer function, Number n1, Number n2, ... ) -> Number

Parameters

function

Required. A number specifying the subtotal function to apply.

n1
n2
…

One or more numbers to subtotal.

Remarks

The arguments can be either numbers or cells, ranges, or arrays that contain numbers. Logical values, text, and empty cells are ignored. If the specified arguments do not contain any numbers, the function returns 0.

The following table illustrates the possible values of function and their meaning.

Example

Formula  Copy Code
=SUBTOTAL(9,A1:A5)

See Also

Function Reference
SUM Function
AVERAGE Function