PrabasTech

Aggregate – New Functions

Aggregate - Excel Functions

Returns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.

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

AGGREGATE(function_num, options, array, [k])

Function_num

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.EXC
19 – QUARTILE.EXC

Download Excel

for Practice

If you watch and understand the entire tutorial along with the practice file, it is a great time saver in such scenarios. 

I hope you understood and practiced the entire concept. Thanks for your time for reading this article.

Want to receive weekly insights  tips & tricks

then register here

Chat
1
Join
PrabasTech Welcome you.
Would you like to join a course?