FUNCTION CATALOGUE / STATISTICAL
MAXIFS Excel function
Returns the largest value meeting conditions.
Correct sentence to use
Find the largest value in [max range] where [condition] is met.
Modify this query in PlainFormula →Example formula
=MAXIFS(D:D,B:B,"London")
Returns the maximum value satisfying criteria.
Syntax
MAXIFS(max_range, criteria_range1, criteria1, …)
Argument signature: max_range, criteria_range1, criteria1, …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.