Manuals/calci/AVERAGE
AVERAGE (A1, A2...) A1, A2 ... are positive integers.
AVERAGE is a function that calculates the average (arithmetic mean) of the arguments.
· Arguments can be numbers, names, arrays, or references.
· Logical values and text representations of numbers are calculated.
AVERAGE
Let’s see an example
AVERAGE (A1, A2…….)
B
12
16
5
18
=AVERAGE (B2:B5) is 12.75
=AVERAGE (B2:B5,4) is 11
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | |
| Row1 | 12 | 12.75 | |
| Row2 | 16 | 11 | |
| Row3 | 5 | ||
| Row4 | 18 | ||
| Row5 | |||
| Row6 |