Math & trig

AGGREGATE function

Aggregate that can skip error values. AGGREGATE works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.

Syntax

=AGGREGATE(function_num, options, ref1, [ref2, ...])
ArgumentUse
function_numrequired
optionsrequired
ref1required, repeatable
ref2optional, repeatable
required

On live data

In Sheets, AGGREGATE sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.

See the integrations

More math & trig functions

ROUNDRound to N decimalsSUMSum of valuesSUMIFSum where one criterion matchesSUMIFSConditional sumSUMPRODUCTSum of element-wise productsABSAbsolute valueACOSArccosine, in radiansACOSHInverse hyperbolic cosineACOTArccotangent, in radiansACOTHInverse hyperbolic cotangentARABICRoman numerals as a numberASINArcsine, in radians

All 84 math & trig functions →

Spreadsheet formulas on live business data

Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.

See the integrations