AVERAGE

Calculate the average of several numbers.

Syntax

AVERAGE(value1,

[value2]

)

value1

First number, cell, range, or JSON array to include in the average. For example: 4, A3, or A3:D3.

[optional] value2

Additional number, cell, range, or JSON array to include in the average. For example: 5, A5, or A5:D5.

AVERAGE(A1:A5) returns 3