Manuals/calci/Average, AverageA, AverageX Example

DATA

	A	B	C	D
1	ID	Amount	Blank	Boolean	SalesDate	Name
2	1			TRUE	29/5/2020	A
3	2	1000		FALSE		B
4	3	2000		TRUE	29/5/2020
5	4	1000		FALSE	28/5/2020	C

AVERAGE()

• Parameters are values or range of cells containing values.
• AVERAGE() returns the average (arithmetic mean) of all the numbers in a column.
  
  

NOTE:

• This function takes the specified column as an argument and finds the average of the values in that column.
• Does not support Logical and Text Values.
• Cells with the value zero are included.
• If Data type is Integer/ Numeric/ Decimal, Average skip the null value.

AVERAGE(A2:A5) = 2.5
AVERAGE(B2:B5) = 1333.33

AVERAGEA()

• Parameters are values or range of cells containing values.
• AVERAGEA() returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values.
  
  

NOTE:

• The AVERAGEA function takes a column and averages the numbers, but also handles non-numeric data types according to the following rules:

• It support Logical values.
• Logical value TRUE count as 1 & FALSE count as 0 (zero).
• Values that contain non-numeric text count as 0 (zero).
• Empty text (“”) counts as 0 (zero).

AVERAGE(A2:A5) = 2.5
AVERAGE(B2:B5) = 1333.33