Manuals/calci/AVERAGEA

AVERAGEA (A1, A2...)

Where A1, A2... ranges of cells, or values.

---

AVERAGEA is a function which calculates the average (arithmetic mean) of the values in the list of arguments.

---

·        Arguments can be numbers, names, arrays, or references.

·        Logical values and text representations of numbers are calculated.

·        Arguments that contain TRUE evaluate as 1; and FALSE evaluate as 0 (zero).

 

---

AVERAGEA 

---

Let’s see an example

AVERAGEA (A1, A2……….)

B

4

6

14

=AVERAGEA (B2:B4) is 8

---

Syntax

---

Remarks

---

Examples

---

Description

---

	Column1	Column2	Column3
Row2	4	8
Row3	6
Row4	14
Row5
Row6

'

---