writer
1,835
edits
Changes
Jump to navigation
Jump to search
Line 3:
Line 3: − + Line 36:
Line 36: − *Parameters are values or range of cells containing values. Line 46:
Line 45: − + − + +
Manuals/calci/Average, AverageA, AverageX Example (view source)
Revision as of 01:07, 20 September 2021
, 01:07, 20 September 2021no edit summary
{| class="wikitable"
{| class="wikitable"
|-
|-
! !! A !! B !!C !!D
! !! A !! B !!C !!D !! E !! F
|-
|-
! 1
! 1
<div style="font-size:24px">'''AVERAGEA()'''</div>
<div style="font-size:24px">'''AVERAGEA()'''</div>
*AVERAGEA() returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values.<br></br>
*AVERAGEA() returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values.<br></br>
*Values that contain non-numeric text count as 0 (zero).
*Values that contain non-numeric text count as 0 (zero).
*Empty text (“”) counts as 0 (zero).
*Empty text (“”) counts as 0 (zero).
'''AVERAGE(A2:A5) = 2.5<br>
'''AVERAGEA(A2:A5) = 2.5<br>
'''AVERAGE(B2:B5) = 1333.33<br></br>
'''AVERAGEA(B2:B5) = 1333.33<br>
'''AVERAGEA(D2:D5) = 0.5<br></br>