ZCubes Wiki

Manuals/calci/Average, AverageA, AverageX Example

Revision as of 19:00, 19 September 2021 by Sahiti (talk | contribs)
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

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/Average,_AverageA,_AverageX_Example&oldid=216755"