MAXIFS
The largest value among the cells that meet the conditions.
Group: Conditional
Syntax
MAXIFS(max_range, range1, criteria1, ...)Example
Exampleexcel
WeCodeAcademyWeCodeAcademyThe largest value among the cells that meet the conditions.
Group: Conditional
MAXIFS(max_range, range1, criteria1, ...)