All functions / Statistics
MAXIFS
The largest value among cells that meet conditions.
Syntax
=MAXIFS(max_range, criteria_range, criteria, [criteria_range1, [criteria_range2], …])
Arguments
max_range: The cells to look at.criteria_range: A range to test.criteria: The condition.criteria_range(optional): More range/condition pairs.
Example
=MAXIFS(C2:C20, B2:B20, "East") → Biggest East sale