Manuals/calci/Average, AverageA, AverageX Example
Jump to navigation
Jump to search
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 |
AVERAGEA ()
- Parameters are values or range of cells containing values.
- AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.
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