AGGREGATE
Returns an aggregate in a list or database.
Math & TrigonometryMath Basics
What it does
Performs calculations (SUM, AVERAGE, etc.) while ignoring hidden rows and errors.
Syntax
AGGREGATE(function_num, options, ref1, [ref2], ...)
Arguments
function_num(number) — 1-19 specifying function (e.g., 9=SUM).options(number) — What to ignore (e.g., 7=hidden rows & errors).ref1(range) — Range to calculate.
Examples
Sum ignoring errors
Sum a range that contains errors.
FORMULA
=AGGREGATE(9, 6, A2:A4)
RESULT
30
SAMPLE DATA
| A | |
|---|---|
| 1 | Values |
| 2 | 10 |
| 3 | 20 |
| 4 | #DIV/0! |