Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelAGGREGATE function in Excel

# AGGREGATE function in Excel

In this post, youâ€™ll learn about the Aggregate function in Microsoft Excel how this can be used for calculations and in formulas in your Excel worksheet.

Aggregate usually means the whole sum of data and the function also means the same.

## Aggregate function

Aggregate function returns aggregate of functions.

It returns the aggregate of range of values of whatever function number is mentioned in the Aggregate function. There are various options in which the Aggregate function can process the provided values.

Syntax â€“ AGGREGATE(function_num,options,ref1,ref2)

It works for a total number of 19 functions. The numbering of the functions are:

1 â€“ AVERAGE

2 â€“ COUNT

3 â€“ COUNTA

4 â€“ MAX

5 â€“ MIN

6 â€“ PRODUCT

7 â€“ STDEV.S

8 â€“ STDEV.P

9 â€“ SUM

10 â€“ VAR.S

11 â€“ VAR.P

12 â€“ MEDIAN

13 â€“ MODE.SNGL

14 â€“ LARGE

15 â€“ SMALL

16 â€“ PERCENTILE.INC

17 â€“ QUARTILE.INC

18 â€“ PERCENTILE.EXE

19 â€“ QUARTILE.EXC

The numbering of options are:

0 â€“ SUBTOTAL and AGGREGATE functions

1 â€“ Hidden rows, SUBTOTAL and AGGREGATE functions.

2 â€“ Error values, SUBTOTAL and AGGREGATE functions.

3 â€“ Hidden rows, Error values, SUBTOTAL and AGGREGATE functions.

4 -Nothing

5 â€“ Hidden Rows

6 â€“ Error values

7 â€“ Hidden rows and Error values

Now letâ€™s take a look at an example.

Here weâ€™ve used the SUM function and included everything between the cell ranges C3 to C8.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021