Each condition is provided with a separaterangeandcriteria.
The syntax used to apply criteria in MAXIFS is a bit tricky because it is unusual in Excel.
See below for details.
The syntax for the MAXIFS function depends on the criteria being evaluated.
Each condition is provided with a separaterangeandcriteria.
With these three arguments, MAXIFS returns the maximum number inmax_rangewhere corresponding cells inrange1meet the condition set bycriteria1.
Additional conditions are applied using range/criteria pairs.
The second condition is defined byrange2andcriteria2, the third condition isrange3andcriteria3, and so on.
MAXIFS can handle up to 126 range/criteria pairs.
Each condition requires a separaterangeandcriteria, and operators need to be enclosed in double quotes ("").
Note conditions are added in range/criteria pairs.
The range E5:E16 is paired with the condition “B”.
Wildcards
Thewildcardcharacters question mark (?
), asterisk(*), or tilde (~) can be used incriteria.
A question mark (?)
matches any one character, and an asterisk (*) matches zero or more characters.
For example, to match a literal question mark (?
~?, ~*, ~~).
The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
MAX Function
The Excel MAX function returns the largest numeric value in the data provided.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
