AVERAGEA
Returns the average (arithmetic mean) of the specified arguments, evaluating text and - false in arguments as 0; - true evaluates as 1.
Syntax
expression.AVERAGEA(args);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| args | Required | ApiRange | ApiName | number | string | number[] | Up to 255 numeric values for which the average value will be returned. The first argument is required, subsequent arguments are optional. Arguments can be numbers, text, or logical values, such as true and false, names, or arrays of numbers. |
Returns
number
Example
Calculate the average of a list that includes numbers, text, and logical values in a spreadsheet.
// Average values when the range contains text or TRUE/FALSE entries in a spreadsheet.
// Include non-numeric cells such as booleans when computing a mean in a spreadsheet.
let worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
let ans = func.AVERAGEA(78, 98, 46, 123, 45, true, false);
worksheet.GetRange("B2").SetValue(ans);