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])


19 functions of AGGREGATE function in Excel


8 behaviours of 2nd argument of Excel AGGREGATE function



Arguments of Array Syntax


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


Leave a comment