AVERAGENOZEROS ​

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

AVERAGENOZEROS(input_a, input_b, ...input_n)

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 ​

AVERAGENOZEROS(1, 3, 3, 0)

AVERAGENOZEROS(1, 3, 3, 0)

Result: 2.33333333333333