# AVERAGEEXZERONEG

The AVERAGEEXZERONEG function returns the average (arithmetic mean) of its arguments excluding zeros and negatives, which can be numbers or node references.

## Syntax

```javascript
averageexzeroneg(value1,[value2]....)
```

## Arguments

value1 – The first node or number to be averaged. This is a required argument.

value2,...– The additional nodes or numbers to be averaged. These are optional arguments.

## Excel Equivalent

[AVERAGEZERONEG](https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6)