# How to Excel AGGREGATE Function

This post will guide you how to use Excel AGGREGATE function with syntax and examples in Microsoft excel.

## Description

The Excel AGGREGATE function returns an aggregate in a list or database and ignore errors or hidden rows.it allow you to apply functions such as: SUM, COUNT, MAX, MIN, SMALL and etc.

The AGGREGATE function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function.

The AGGREGATE function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

## Syntax

The syntax of the AGGREGATE function is as below:

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

Where the AGGREGATE function arguments are:
function_num – This is a required argument. The function that you want to use and it can be any of the below number(1-19).

Options – This is a required argument.  A numeric value that determines which values to ignore. If the options is omitted,  the options value will be set to 0.

Ref1 – This is a required argument. The first numeric argument for the functions in aggregate function.
Ref2 – This is an optional argument. Numeric arguments 2 through 253.

## Example

The below example will show you how to use Excel AGGREGATE function to return an aggregate in a list.

#1 = AGGREGATE (4,6,B1:B3)

Note: the above formula will calculate the maximum value in the range B1:B3 and ignoring error values.

#2 = AGGREGATE (14,6,B1:B3,2)

Note: The above excel formula will calculate the second largest value in the range B1:B3 and ignoring error values.

## Video

This Excel video tutorial will introduce the AGGREGATE function—a multifaceted tool for summarizing data with the flexibility to skip errors and hidden rows.