|
AVERAGECOLS Function
Averages each column of the Table_Range to produce a horizontal array of the averages of the columns. Only numbers are averaged: logical, text and empty cells are excluded
Dynamically adjusts to the number of rows and columns in Table_Range:
use AVERAGECOLS when you want non-floating totals for dynamic arrays.
AVERAGECOLS is a multi-threaded, non-volatile array function.
AVERAGECOLS Syntax
AVERAGECOLS (Table_Range [, Exclude_Cols])
Table_Range
Array, Table, Range or Spill reference whose columns are to be averaged.
Exclude_Cols (Optional. Default no columns will be excluded)
Optional. If omitted all columns will be averaged.
A list (array or range) identifying the columns that are not to be averaged, given as one of:
If Table_Range is not an array: One or more ranges within Table_Range. Multiple disjoint ranges must be enclosed in ( ) – for example (A1:B1,D1) results in columns 1,2 and 4.
Alphabetic labels are used as lookup values in the first row of Table_Range to find the columns. These labels can be supplied in an array or a range.
Relative column numbers are used directly.
These column numbers can be supplied in an array or range.
For example {2,4} gets the second and fourth column of the Table_Range.
Negative numbers work from right to left so {-1, -2) gets the last two columns of the Table_Range.
Zero acts as an include operator.
{1,0,5} results in Columns 1 through 5 inclusive
{1,5} results in Column 1 and Column 5 only
{5,0} results in Column 5 and all Columns after Column 5
{0,5} results in the first 5 Columns
|
