This function returns the average of the values of all items in an item string. During the calculation, the system will utilize the Val( ) function to convert items to numbers.
Syntax
ListAverage(cValueExpr,cSeparator)
cValueExpr |
Item string (or function returning an item string) |
cSeparator |
Item separator (can be more than 1 character). Default to ',' |
Returns
Numeric
Example
ListAverage("8,4,3")
Returns 5
See also
ListAscItem( ) | ListAscVal( ) | ListDescItem( ) | ListDescVal( ) | ListItem( ) | ListVal( ) | ListSum( ) | ListCount( ) | ListFilter( ) | ListStdDev( )
Page url: http://www.racematenet.com/english/help/index.html?listaverage.htm