### Excel AGGREGATE Function

This Excel Tutorial demonstrates how to use the Excel AGGREGATE Function in Excel to perform calculates to a database, with formula examples.

## AGGREGATE Function Description:

The AGGREGATE Function Calculates specified calculations (sum, average, etc.) for a database or a list.

## Formula Examples: Example Formula Result
Average =AGGREGATE(E5,F5,\$B\$5:\$B\$7) 3.66666666666667
Count =AGGREGATE(E6,F6,\$B\$5:\$B\$7) 3
Sum =AGGREGATE(E7,F7,\$B\$5:\$B\$7) 11
Percentile.Inc =AGGREGATE(E8,F8,\$B\$5:\$B\$7,G8) 2.8

## Syntax and Arguments:

The Syntax for the AGGREGATE Formula is:

### Function Arguments ( Inputs ):

function_num

options

array

k – 2 different options

Use the AGGREGATE Function to perform defined calculations on a database or list.

## AGGREGATE Examples in VBA You can also use the AGGREGATE function in VBA. Type:
`Application.Worksheetfunction.Aggregate(function_num,options,array,k)`
For the function arguments (function_num, etc.), you can either enter them directly into the function, or define variables to use instead.

`=AND(`  