# Manuals/calci/Average, AverageA, AverageX Example

Jump to navigation
Jump to search

**DATA**

A | B | C | D | E | F | |
---|---|---|---|---|---|---|

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()**

- 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 counts as 1 & FALSE counts as 0.
- Values that contain non-numeric text count as 0.
- Empty text (" ") counts as 0.

**AVERAGEA(A2:A5) = 2.5**

**AVERAGEA(B2:B5) = 1333.33**

**AVERAGEA(D2:D5) = 0.5**

**AVERAGEX()**

- AVERAGEX() calculates the average (arithmetic mean) of a set of expressions evaluated over a table.

**NOTE:**

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

- The function takes a table as its first argument, and an expression as the second argument.
- The AVERAGEX function enables you to evaluate expressions for each row of a table, and then take the resulting set of values and calculate its arithmetic mean.
- You cannot include non-numeric or null cells. Both the table and expression arguments are required.
- When there are no rows to aggregate, the function returns a blank. When there are rows, but none of them meet the specified criteria, then the function returns 0.
- Does not support Logical/ boolean values.

**AVERAGEX(A2:A5) = 2.5**