AGGREGATE

Rational.

To give the value of the function used. 

Description

The Excel AGGREGATE Function returns a value after calculating based on the function from Sum, Average, etc (1 to 19) you applied and the options used for ignorance. 
For example, suppose that you have a number with few cells empty and contained error in a column and the user wants to find the sum, but some function will show an error. For this we will use Aggregate the formula can be =AGGREGATE(B7,C7,D4:D10) the Excel numbers add and returns 124.

Syntax

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

Parameters

Function_num– The number which divides

options – Selects numbers for ignorance (1 to 7).

Array – The range of cells.

K [optional]– It is the second reference (k).

Return Value

Aggregate value

Key Notes

• The Aggregate function shows error #VALUE! in a cell, if the second argument i.e. k required but not given in the formula. Like in cell E9 if the k is not given it shows error.
• The Aggregate function shows error #N/A in a cell if the range contained an error and you did not select options of numbers for ignorance.

The options (1 to 7) used to remove the error, hidden rows, etc in brief