deepcalc
DocsAGGREGATE

AGGREGATE

View as markdown/docs/functions/aggregate.md Ask Claude about this pageOpens Claude with this page's address

Aggregates a range with a chosen function, optionally ignoring error values.

  • Excel: Differs in detail
  • Google Sheets: No equivalent
  • Returns: Number

Examples

=AGGREGATE(9, 6, A1:A5)
A
1 10
2 20
3 30
4 40
5 50
Result 150

Syntax

AGGREGATE(function_num, options, range…)
function_num
number required
options
number required
range…
range required
ABSReturns absolute value of a number. ACOSReturns arccosine of a number. ACOSHReturns inverse hyperbolic cosine. ACOTReturns the arccotangent of a number. ACOTHReturns the inverse hyperbolic cotangent. ADDAdds two numbers: sheets exposes the + operator as a function.