Spread Formula Reference
MAXIFS
Formula Functions > Functions M to Q > MAXIFS

This function returns the maximum value among the values in cells or the cell range provided the specified set of conditions or the criteria meets.

Syntax

MAXIFS(max_range, range1, criteria1, [range2,criteria2],..)

Arguments

This function has the following arguments:

Argument Description
max_range Refers to the range of cells in which maximum will be calculated
range1 Refers to the set of cells to be calculated based on the criteria
criteria1 Refers to the criteria (in terms of number, expression, or text) according to which cells will be calculated
range2, criteria2... [Optional] Refers to the additional ranges and their corresponding criteria

Remarks

If the size and shape of max_range and rangeN (refers to range1,2,3,4,......N) arguments is not same, this function will return the #VALUE! error.

If cells do not match with the specified criteria, this function will return 0.

Data Types

Accepts either numeric data, expression, or text for all arguments. Returns numeric data.

Examples

MAXIFS(C4:C7,B4:B7,"325") gives the result 656

MAXIFS(C4:C7,B4:B7,"55") gives the result 0

Version Available

This function is available in Spread for Windows Forms 11.0 or later.