Learn How to Use Microsoft Excel AGGREGATE Function

Microsoft Excel AGGREGATE Function

The main function of the Microsoft Excel AGGREGATE function is to return the Aggregate calculation that implies - Average, max, Count, etc., and sometimes the operation ignores the hidden rows and errors. You can perform nineteen operations using the Aggregate function which is available, and specified by the first argument is given below. So, with the help of the Microsoft Excel AGGREGATE function, you can easily return the Aggregate calculation.     

Return Value of AGGREGATE Function

The return value depends on the function specified.

Syntax of AGGREGATE Function

=AGGREGATE(function-number, options, ref1, ref2)

Where the arguments:

function-number: This is the operation to perform (1-19).

options: There are the values to ignore (0-7).

ref1: First argument.

ref2: Second argument (k).

How to Use Microsoft Excel AGGREGATE Function?

Microsoft Excel AGGREGATE function is to return the Aggregate calculation that implies - Average, max, Count, etc., and sometimes the operation ignores the hidden rows and errors. You can perform nineteen operations using the Aggregate function which is available, and specified by the first argument. So, with the help of the Microsoft Excel AGGREGATE function, you can easily return the aggregate of calculation, with the help of 19 operations available, and the operations performed are specified as the number, which appears as the first argument in the function. The second argument, options, controls how AGGREGATE handles errors and values in hidden rows. We have provided the table below for all available options.     

Function numbers

The table here lists the function numbers available with the AGGREGATE function, along with the name of the related function. The third column, Ref2, indicates the second argument value expected when required.

...

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel