AGGREGATE function is very useful when we need to do a series of summary statistics calculations on subsets of data in Excel 2013
AGGREGATE function combines 19 commonly used excel stand-alone functions like SUM, AVERAGE, MEDIAN, COUNT etc.
AGGREGATE function is introduced to improve on the old SUBTOTAL function adding eight important functions like MEDIAN, MODE, PERCENTILE and QUARTILE
The key advantage of AGGREGATE function is that it includes options to ignore hidden rows, error values or both. Thus, it is very useful for performing operations only on filtered data.
Syntax:
=AGGREGATE(function_num, options, array, [k])
=AGGREGATE(function_num, options, ref1, [ref2], …)
Arguments:
array: range of cells
k: required argument for percentile and quartile values
ref1: first number in a string of cell references
AGGREGATE function combines 19 commonly used excel stand-alone functions like SUM, AVERAGE, MEDIAN, COUNT etc.
AGGREGATE function is introduced to improve on the old SUBTOTAL function adding eight important functions like MEDIAN, MODE, PERCENTILE and QUARTILE
The key advantage of AGGREGATE function is that it includes options to ignore hidden rows, error values or both. Thus, it is very useful for performing operations only on filtered data.
Syntax:
=AGGREGATE(function_num, options, array, [k])
=AGGREGATE(function_num, options, ref1, [ref2], …)
Arguments:
array: range of cells
k: required argument for percentile and quartile values
ref1: first number in a string of cell references
No comments:
Post a Comment