# AVERAGEA Function. Get the average including non-numeric values.

Japanese version.

Get the average including non-numeric values.

## How it works

`=AVERAGEA(number1 to 255)`

## Example Results

### Specify cell range.

Basically, a range of cells is specified.

#### Non-numeric characters are mixed in

If non-numeric characters such as alphabetic characters are mixed in, the non-numeric characters are averaged as 0.

In this example, there is a difference between the AVERAGE function and this.

#### 0 and blank

Zeros are included in the average calculation, but spaces are ignored.

In the example below, the calculation is 10 divided by 5.

This rule is identical to the AVERAGE function.

However, if a cell contains a formula such as ="", it will be treated as 0 even though it looks the same as a blank space.
This behavior differs from that of the AVERAGE function.

#### Error value

If an error cell is mixed in, the AVERAGE function will also result in an error.

This should be noted when including the results of XLOOKUP and VLOOKUP functions in the calculation.

### Specify other than cell range.

It is also possible to return a range of cells as the result of a function argument. In this case, the average value is taken from the result of the function.

List of functions that result in a range of cells.

It can also be specified as an array.

`=AVERAGEA({5,2,10,1,-8})`

Multiple values can also be specified simply by separating them with commas.

`=AVERAGEA(5,2,10,1,-8)`

Multiple cells can be specified by separating them with commas.

### Spill

Spill when using the BYROW or BYCOL function.

`=BYROW(A1:C3,LAMBDA(r,AVERAGEA(r)))`
`=BYCOL(A1:C3,LAMBDA(c,AVERAGEA(c)))`

---