=AVG
The AVG function returns the average of a list of numbers separated by semicolons. A value that is blank or is not a number is left out of both the total and the count, so a field nobody has filled in yet does not pull the average down as a zero.
Syntax
Section titled “Syntax”=AVG(Parameter1; Parameter2; Parameter3; ...)Parameters
Section titled “Parameters”- Parameter1, Parameter2, Parameter3, … – The numbers or field tokens to average. Include as many as you need.
How It Works
Section titled “How It Works”-
Adds up every value that is a number and divides by how many numbers it found.
-
Skips values that are empty or not numbers.
=AVG(5; ; 5)returns 5, not 3.33, because the blank in the middle is not counted. -
Returns nothing when no value in the list is a number. An average of nothing has no value, and a 0 would look like the lowest possible score.
-
Ignores thousands separators and currency symbols, so
=AVG($1,000; 3,000)returns 2000.
Usage Notes
Section titled “Usage Notes”-
Formula functions are case sensitive and must be written in ALL CAPS.
-
Works with numbers only. To find the earliest or latest of several dates, use =MIN or =MAX.
-
The result keeps its decimals. To round it, wrap it in =ROUND, for example
=ROUND(1; =AVG([[Field: Service (Number)]]; [[Field: Timeliness (Number)]])). -
Useful for an overall score worked out from several score fields on the same process, where a question that was skipped should not count against the result.
-
To add the values instead of averaging them, use =SUM. SUM returns 0 when nothing in the list is a number; AVG returns nothing.
Example
Section titled “Example”=AVG(2; 4; 9)Returns: 5
Example - A blank value is skipped
Section titled “Example - A blank value is skipped”=AVG(4; ; 5)Returns: 4.5
Keywords
Section titled “Keywords”AVG, average, mean, average of fields, overall score, skip blank values, list of numbers, numeric functions, formula function, calculated value