|
LISTDISTINCTS.SUM Function
LISTDISTINCTS.SUM 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 sum of the SumColumn.
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 sum of the SumColumn for each distinct item.
LISTDISTINCTS.SUM Syntax
LISTDISTINCTS.SUM (theInputData, 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 summed.
LISTDISTINCTS.SUM and LISTDISTINCTS.AVG ignore cells in the SumColumn containing True/False, numbers which are text and text.
|
