AVERAGEA函数计算参数列表中值的平均值(算术平均值)。
AVERAGEA (value1, [value2] ...)
Argument | 描述 | Required/Optional |
---|---|---|
Value1 | 1 to 255 cells, ranges of cells, or values for which you want the average. | Required |
Value2,... | Optional |
争论 can be the following −
数字
包含数字的名称,数组或引用
数字的文本表示形式。
逻辑值,如TRUE和FALSE。
Logical values and text representations of 数字 that you type directly into the list of arguments are counted.
争论 that contain TRUE evaluate as 1. 争论 that contain FALSE evaluate as 0 (zero)
包含文本的数组或引用参数的值为0(零)
空文本("")的值为0(零)
如果参数是数组或引用,则仅使用该数组或引用中的值。数组或引用中的空单元格和文本值将被忽略。
If you do not want to include logical values and text representations of 数字 in a reference as part of the calculation, use the AVERAGE function.
争论 that are error values or text that cannot be translated into 数字 cause errors.
如果该函数的参数都是对空白单元格的引用,则AVERAGEA返回#DIV/0!错误。
来源:LearnFk无涯教程网
If any of the arguments that is supplied directly to the Function are text values that cannot be interpreted as 数字, AVERAGEA returns #VALUE! Error.
Excel 2007,Excel 2010,Excel 2013,Excel 2016
祝学习愉快!(内容编辑有误?请选中要编辑内容 -> 右键 -> 修改 -> 提交!)