Excel Function : AGGREGATE
Category
Math and trigonometry
Description
Returns an aggregate in a list or database
Microsoft Excel Reference Page
https://support.office.com/en-us/article/AGGREGATE-function-43b9278e-6aa7-4f17-92b6-e19993fa26df
Syntax and Description of the AGGREGATE Excel Function
:
=AGGREGATE(14,6,A2:L2/((A2:L2<>A2:L2)+A2:L2),1)
Note that this will return #DIV/0! if any of the cells in the range A2:L2 is blank.
About AGGREGATE Excel Function
The AGGREGATE function returns a numeric aggregate value from a list or array of values. AGGREGATE has the following arguments: function_num - Required. The number 1, 2, 3, 4, or 5 that specifies the function to use to aggregate values. The following table lists the functions that you can specify and what they do. options - Optional. A number or text value that specifies options for the function_num argument. ignore_error - Required. A number, reference, or text constant that specifies whether to ignore errors. If the ignore_error argument is a reference, it must refer to a cell or range of cells that contain numbers, logical values
