3.5.2.29 Maxifs

Description

Minimum Origin Version Required: 2019 SR0

This function returns the maximum value from a given dataset vd that satisfies a specified condition con.

Syntax

double Maxifs(vector vd, string con$)

Parameters

vd

A dataset or specified column in Origin worksheet from which the maximum value is found.

con

the condition you use to find a sub-range within vd. It can be an expression and must be inclosed by double quotation ("").

Return

Return the maximum value from a set of values that satisfies a specified condition.


Example

col(A) = data(1,32);
maxifs(col(A),"col(A) > 5 && col(A) < 10")=; // Return 9
//simpler condition
maxifs(col(A), "<10")=;

See Also

Countif, Minifs