writer
1,835
edits
Changes
Manuals/calci/Average, AverageA, AverageX Example (view source)
Revision as of 01:00, 20 September 2021
, 01:00, 20 September 2021no edit summary
*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.
'''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<br>
'''AVERAGE(A2:A5) = 2.5<br>
'''AVERAGE(B2:B5) = 1333.33<br></br>
'''AVERAGE(B2:B5) = 1333.33<br></br>