# AGGREGATE

The AGGREGATE function is a powerful tool used for performing various calculations on ranges of data. It offers a wide range of pre-defined functions to apply to the data, and it also provides the option to ignore hidden rows or error values within the range.

## Syntax

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

The AGGREGATE function serves as a versatile tool for performing calculations on data ranges within Excel. It provides a wide array of aggregate functions, from simple operations like SUM and AVERAGE to more complex statistical and financial calculations, offering flexibility and efficiency in data analysis tasks. This function empowers users to handle data with precision and tailor the calculations to specific requirements, ensuring accurate and meaningful results for decision making and analysis purposes. Additionally, the AGGREGATE function allows customization by incorporating options to disregard error values or hidden rows, adding further control to the calculation process for enhanced accuracy and relevance of the output.

## Examples

To find the average of a range, excluding hidden rows and error values, the AGGREGATE formula would be: =AGGREGATE(1, 6, A1:A10)

To calculate the maximum value in a range, considering only visible cells, the AGGREGATE formula would be: =AGGREGATE(4, 5, B1:B20)

## Questions

What are some common aggregate functions that can be used with the AGGREGATE function?

The AGGREGATE function supports a variety of aggregate functions, including SUM, AVERAGE, COUNT, MAX, MIN, STDEV, and many others. The function_num parameter determines the specific aggregate function to be applied to the data range.

How can the AGGREGATE function handle hidden rows or error values within the data range?

The options parameter in the AGGREGATE function allows for customization to ignore hidden rows (option 2) or error values (option 3), providing control over the data considered in the calculation. This feature ensures the accuracy and relevance of the calculated results.

Can the AGGREGATE function perform calculations on multiple ranges of data?

Yes, the AGGREGATE function allows for multiple ranges of data to be included in the calculation, enabling comprehensive analysis across diverse data sets. This flexibility enhances the utility of the function in addressing complex analytical needs.

SUM
AVERAGE
COUNT
MAX
MIN
STDEV
LARGE
SMALL