@AVG

@AVG(list) calculates the average of a list of values.



Arguments

list can contain any of the following, in any combination: numbers, numeric formulas, and addresses or names of ranges that contain numbers or numeric formulas. Separate elements of list with argument separators; such as a ; (semicolon).

Text labels within ranges in list do not cause statistical @functions to evaluate to ERR indicating an error. A value of 0 (zero) is assigned to all text labels in list (either in a range or listed individually) and includes them in calculations. For example, if you use @AVG to calculate the average of the values in a range and the range contains a label, the label is considered to have the value 0 when it calculates the average.

Your spreadsheet ignores blank cells (cells that contain no data) in multiple-cell ranges in list, but does not ignore references to blank cells listed individually. For example, if you use @AVG to average the values in a range that spans four cells (A1..A4), and the range contains a blank cell, the sum is divided by three to find the correct average. If you list those four cells individually, however (A1;A2;A3;A4), the sum is divided by four.



Examples

@AVG(A2..A5) = 252.75, when A2..A5 contains the values 160, 227, 397, and 227.

@AVG(A1..A5) = 202.20, when A1..A5 contains the values 160, 227, 397, and 227, and the label January. (@AVG counts the label as zero and uses it in the calculation.)



See also
More power with @functions
@functions A-Z