AVERAGEEXZERO

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

Syntax

averageexzero(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.

Example

averageexzero(East, South, Central, West)

Returns the average of the four regions excluding zeros

Excel equivalent

AVERAGEEXZERO