writer
1,835
edits
Changes
Jump to navigation
Jump to search
Line 22:
Line 22: − + − + Line 31:
Line 31: + + + + + + + + + + + + + + +
Manuals/calci/Average, AverageA, AverageX Example (view source)
Revision as of 01:04, 20 September 2021
, 01:04, 20 September 2021no edit summary
<div style="font-size:24px">'''AVERAGEA()'''</div>
<div style="font-size:24px">'''AVERAGE()'''</div>
*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.<br></br>
*AVERAGE() returns the average (arithmetic mean) of all the numbers in a column.<br></br>
<div style="font-size:16px">'''NOTE:'''</div>
<div style="font-size:16px">'''NOTE:'''</div>
*Cells with the value zero are included.
*Cells with the value zero are included.
*If Data type is Integer/ Numeric/ Decimal, Average skip the null value.
*If Data type is Integer/ Numeric/ Decimal, Average skip the null value.
'''AVERAGE(A2:A5) = 2.5<br>
'''AVERAGE(B2:B5) = 1333.33<br></br>
<div style="font-size:24px">'''AVERAGEA()'''</div>
*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.<br></br>
<div style="font-size:16px">'''NOTE:'''</div>
* 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<br>
'''AVERAGE(A2:A5) = 2.5<br>
'''AVERAGE(B2:B5) = 1333.33<br></br>
'''AVERAGE(B2:B5) = 1333.33<br></br>