- Picture and text skills
- Case
MINIFS function returns the minimum value between a set of cells specified by a given condition or criterion.
Grammar
MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
min_range (required) The actual range of cells from which the minimum value is determined.
criteria_range1 (required) is a set of cells used for criteria calculations.
criteria1 (required) Criteria used to determine which cells have the smallest value, formatted as a number, expression, or text.
The same set of conditions applies to the MAXIFSSUMIFS and AVERAGEIFS functions.
criteria_range2,criteria2,... (optional) Additional ranges and their associated criteria. Up to 126 area/condition pairs can be entered.
Description
min_range and criteria_rangeN parameters must be the same size and shape, otherwise these functions return a #VALUE! error
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-xue-he-san-jiao-han-shu-qiao-yong-MINIFS-han-shu-an-tiao-jian-qiu-zui-xiao-zhi.html
支付宝扫一扫 
评论列表（196条）
测试