For the complete documentation index, see llms.txt. This page is also available as Markdown.

AVERAGEEXZERONEG

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

Syntax

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

Last updated

Was this helpful?