Parameter List
Syntax
MAXIFS(max_range, criteria_range1, criterion1,
[criteria_range2, criterion2]
)max_range
The range of numbers from which the maximum value is calculated. For example: A1:A5.
criteria_range1
The range of conditional values to check against criterion1. Must be of the same size as sum_range. For example: B1:B5.
criterion1
The condition to apply to criteria_range1. For example: ">20".
[optional] criteria_range2
An additional range of conditional values to check against criterion2.