To calculate the average of a set of numbers.

`=AVERAGE(number1, [number2], ...)`

- number1 - a number or reference to a cell with numeric values
- number2 - [OPTIONAL] a number or reference to a cell with numeric values
- AVERAGE takes up to 255 total arguments of numbers, cell references, ranges, arrays, or constants

`=AVERAGE(A2:A7)`

averages the numbers in A2:A7.

`=AVERAGE(A2:A4,A7)`

averages the first three numbers (A2:A4) with the the last number in A7.

The AVERAGE function in Sourcetable calculates the average numerical value of its arguments.

- AVERAGE can handle up to 255 individual arguments. The arguments can include numbers, cell references, ranges, arrays, and constants.
- Sourcetable calculates the average by summing all numeric values and dividing by the count of numeric values.
- AVERAGE ignores empty cells as well as cells with text or logical values.
- AVERAGE includes the zero (0) value in its calculation. Use the AVERAGEIF and AVERAGEIFS functions if you are trying to ignore zero values.

The AVERAGE function is one of Sourcetable's statistical functions. It calculates a mean average of a series of numbers.

The AVERAGE function works by calculating the arithmetic mean of a set of arguments.

The AVERAGE function is useful if you want to calculate an average of a series of numbers as an arithmetic mean.

Yes, the AVERAGE function automatically handles array results.

Drop CSV