AGGREGATE Function in Excel

Syntax of AGGREGATE Function

Two Syntaxes of AGGREGATE function in Excel

1. Reference Syntax:

AGGREGATE(function_num, options, ref1, [ref2], …)

2. Array Syntax:

AGGREGATE(function_num, options, array, [k])

Function_num

19 functions of AGGREGATE function in Excel

Options

8 behaviours of 2nd argument of Excel AGGREGATE function

Ref1

[Ref2],…

Arguments of Array Syntax

Table-1

How to use AGGREGATE Function in Excel?

Example #1: Sum using AGGREGATE and SUM formula when there is an error value in a range of cells

1st example of AGGREGATE function in Excel

2nd Example of Excel AGGREGATE function

Limitations of Excel AGGREGATE Function

2 thoughts on “AGGREGATE Function in Excel”

  1. Good job. If you explain it with your voice then it will be more effective

    Reply

Leave a comment