Difference between revisions of "Manuals/calci/Average, AverageA, AverageX Example"
Jump to navigation
Jump to search
| Line 20: | Line 20: | ||
| 4 || 1000 || || FALSE || 28/5/2020 || C | | 4 || 1000 || || FALSE || 28/5/2020 || C | ||
|} | |} | ||
| − | |||
| − | <div style="font-size: | + | <div style="font-size:24px">'''AVERAGEA ()'''</div><br/> |
| − | |||
*Parameters are values or range of cells containing values. | *Parameters are values or range of cells containing values. | ||
**AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values. | **AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values. | ||
| − | + | '''AVERAGE([A1:A5])<br></br> | |
| − | |||
Revision as of 18:47, 19 September 2021
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.
AVERAGE([A1:A5])