Manuals/calci/AVERAGE
Jump to navigation
Jump to search
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 |