ReferenceFunctionsMath Functions

AGGREGATE

Reference for the AGGREGATE function.

Summary

Reference for the AGGREGATE function.

=AGGREGATE(A1, B1)

Category

Math

Signature

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

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

Arity

min 3, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

VOLATILEREDUCTIONNUMERIC_ONLYSTREAM_OK

Source

ACOTH

ACOTH: Returns the inverse hyperbolic cotangent of a number.

ARABIC

Converts a Roman numeral string to its Arabic numeric value.