Parameter List
Syntax
MINIFS(min_range, criteria_range1, criterion1,
[criteria_range2, criterion2]
)min_range
The range of numbers from which the minimum 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.