---
url: /cube-functions/averagenozeros.md
description: Returns the average value from a range of inputs ignoring zeroes.
---

# AVERAGENOZEROS

Returns the average value from a range of inputs ignoring zeroes.

```js
AVERAGENOZEROS(input_a, input_b, ...input_n)
```

#### Parameters

* `input_a` - Input to be evaluated.
* `input_b` - Input to be evaluated.
* `input_n` - Input to be evaluated. `(optional)`

#### Examples

```js
AVERAGENOZEROS(1, 3, 3, 0)
```

**Result:** `2.33333333333333`