|
LISTDISTINCTS.AVG Function
LISTDISTINCTS.AVG outputs a multi-column array of the cells or rows from the input data, where the first column/columns are the distinct items/rows and the last column is the count of that item.
If ByRows is true then the output rows are the distinct rows, but if ByRows is false then the output is 2 columns: the first column is a list of all the distinct items in the input data and the second column is a average of the SumColumn for each distinct item.
LISTDISTINCTS.AVG Syntax
LISTDISTINCTS.AVG (theItems, SumColumn, Ignore, ByRows, Case_Sense, Sort, FillType)
Parameters apart from SumColumn are explained in the LISTDISTINCTS function.
SumColumn
Can be a range or array of constants or an expression returning an array, and must be arranged as a vertical column.
The number of rows should be the same as the number of rows in theInputData.
The values for each corresponding distinct row in theInputData will be averaged.
LISTDISTINCTS.SUM and LISTDISTINCTS.AVG ignore cells in the SumColumn containing True/False, numbers which are text and text.
|
