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.


Frequently Asked Questions

What is the AVERAGE function?
The AVERAGE function is one of Sourcetable's statistical functions. It calculates a mean average of a series of numbers.
How does the AVERAGE function work?
The AVERAGE function works by calculating the arithmetic mean of a set of arguments.
What is the AVERAGE function used for?
The AVERAGE function is useful if you want to calculate an average of a series of numbers as an arithmetic mean.
Does the AVERAGE function work with arrays?
Yes, the AVERAGE function automatically handles array results.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV