ExcelFlux

AGGREGATE function

an aggregate in a list or database.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Use operation 9 for a sum and option 6 to ignore errors. The sample inputs establish a clean baseline.

A worked example from the workbook

RowABC
6InputComparisonGroup
7234
8123
9000
Record 1
=AGGREGATE(9,6,A7:C7)

Expected result9

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=AGGREGATE(9,6,A7:C7)
Turkish Excel · tr-TR
=TOPLAMA(9;6;A7:C7)

Worked examples

Use operation 9 for a sum and option 6 to ignore errors. The sample inputs establish a clean baseline.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Input Comparison Group
7 2 3 4
8 1 2 3
9 0 0 0
Case Formula Expected result
Record 1 =AGGREGATE(9,6,A7:C7) 9
Record 2 =AGGREGATE(9,6,A8:C8) 6
Record 3 =AGGREGATE(9,6,A9:C9) 0
Microsoft Excel reference