AVERAGECOLUMN |
Description
Calculates the average of a numeric
or date column.
Syntax
AVERAGECOLUMN(value,
column1, column2, ...)
Value is
the column that contains the values you want to average. The column
must be either a numeric or date column.
Column1, column2,... are up to
30 optional columns that define the aggregation context for the average
calculation. Averages are calculated for each unique combination
of the group_by columns.
When the result of AVERAGECOLUMN is
given as the final value for a new column in a transform worksheet, as
in the example below, each row will get the value of AVERAGECOLUMN that
corresponds to its particular aggregate values.
If no group_by columns are
provided, the average is calculated
across all rows in the output sheet.
For dates, AVERAGECOLUMN averages the date/time values,
AVERAGECOLUMN ignores empty
values in the value column, but treats an empty value in a group_by
column as a distinct value, and correctly groups including the empty
values.
Example
In
the following we see
how AVERAGECOLUMN works with a numeric column and a single aggregation
column. The calculated value is entered in each row.
Sample
Data
Unit
Sales
|
Store
|
=AVERAGECOLUMN(Unit
Sales,Store) |
NUMBER
|
TEXT
|
NUMBER
|
157
|
West |
157
|
127
|
Central
|
127
|
|
Central
|
127
|
353
|
North
|
353
|
104
|
East
|
104.5
|
105
|
East
|
104.5
|
|
 User Comments |
 |
|
| Click Here to be the first to post a comment. |
Support Home
| 
Glossary | 
Contact Us 
