ReferenceFunctionsMath Functions

SUBTOTAL

Reference for the SUBTOTAL function.

Summary

Reference for the SUBTOTAL function.

=SUBTOTAL(A1, B1)

Category

Math

Signature

SUBTOTAL(arg1, arg2, ... argN: Number (Range))

This function accepts a repeating argument pattern (min args: 2).

Arity

min 2, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

VOLATILEREDUCTIONNUMERIC_ONLYSTREAM_OK

Source

SQRTPI

SQRTPI: Returns the square root of a number multiplied by pi.

SUM

SUM: Adds numeric values across scalars and ranges.