AVERAGE function

Applies To

„SharePoint Server“ prenumeruojamas leidimas „SharePoint Server 2019“ „SharePoint Server 2016“ „SharePoint Server 2013“ „SharePoint Server 2013 Enterprise“ „SharePoint“, esantis „Microsoft 365“ SharePoint Foundation 2010 „SharePoint Server 2010“ „SharePoint“, esantis „Microsoft 365 Small Business“ Windows SharePoint Services 3.0

Returns the average (arithmetic mean) of the arguments.

Syntax

AVERAGE(number1,number2, ...)

Number1, number2, ... are 1 to 30 numeric arguments for which you want the average.

Remarks

The arguments must be either numbers or references that contain numbers.
If an array or column reference argument contains text, logical values, or is empty, those values are either ignored or return the #VALUE! error value; however, arguments with the value zero are included.

Example

Col1	Col2	Col3	Col4	Col5	Formula	Description (Result)
10	7	9	27	2	=AVERAGE([Col1], [Col2], [Col3], [Col4], [Col5])	Average of the column numbers (11)
10	7	9	27	2	=AVERAGE([Col1], [Col2], [Col3], [Col4], [Col5], 5)	Average of the column numbers and 5 (10)