AVERAGE

Averages a list of numbers

AVERAGE( value 1, [value 2 ...] )

Averages a list of numbers, ignoring any blank values.

Arguments

Input	Description
value 1	numeric column or value
[value 2...]	Optional. Column(s) to be included in the calculation; will output a row-wise calculation when this argument is provided.

Outputs

Numerical average of input values

Examples

Averaging a single column returns the average value of that column for every row.

Averaging multiple columns returns the average by rows.