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
Last updated