ReferenceFunctionsStatistics Functions

HARMEAN

HARMEAN: Returns the harmonic mean of positive numeric values.

Summary

HARMEAN emphasizes smaller values and is useful for averaging rates and ratios.

Remarks

All numeric inputs must be strictly greater than 0.
Returns #NUM! if any value is <= 0, or if no numeric values are provided.
Non-numeric values in referenced ranges are ignored.

Examples

Harmonic mean from scalar values

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1.7142857142857142

Harmonic mean from a range

Grid

Cell	Value

Formula

=

Result

Not evaluated yet.

Expected

3

FAQ

Why does HARMEAN fail on zeros?

Harmonic mean uses reciprocals, so inputs must be strictly positive.

Runtime metadata

Category

Statistics

Signature

HARMEAN(arg1…: Number (Range))

This function accepts a repeating argument pattern (min args: 1).

Arity

min 1, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PUREREDUCTIONNUMERIC_ONLY

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

GROWTH

GROWTH: Returns fitted values from an exponential trend model.

HYPGEOM.DIST

HYPGEOM.DIST: Returns hypergeometric probabilities for successes drawn without replacement.

On this page

Summary Remarks Examples Related functions FAQ Why does HARMEAN fail on zeros?Runtime metadata