Finds the average (arithmetic mean) for the cells specified by a given set of conditions or criteria.
Name | Type | Description |
arg1 | ApiRange | The range of cells which will be evaluated. |
arg2 | number | string | The first condition or criteria in the form of a number, expression, or text that defines which cells will be used to find the average. |
arg3 | ApiRange | The actual cells to be used to find the average. If omitted, the cells in the range are used. |
arg4 | number | string | Up to 127 additional conditions or criteria in the form of a number, expression, or text that defines which cells will be used to find the average. These arguments are optional. |
arg5 | ApiRange | Up to 127 actual ranges to be used to find the average. If omitted, the cells in the range are used. These arguments are optional. |