# AVERAGE

Formulas / AVERAGE
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

## Examples

• =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.

## Summary

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.