关注我们

JavaScript 中的 MINIFS函数

描述

MINIFS函数返回由一组给定条件或条件指定的单元格中的最小值。 Excel 2016中已添加此功能。

MINIFS (min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Argument	描述	Required/Optional
min_range	The actual range of cells in which the minimum will be determined.	Required
criteria_range1	Is the set of cells to evaluate with the criteria.	Required
criteria1	是数字,表达式或文本形式的条件,用于定义将被判断为最小的单元格。无涯教程网一组相同的条件适用于MAXIFS,SUMIFS和AVERAGEIFS函数。链接：https://www.learnfk.comhttps://www.learnfk.com/javascript/advanced-excel-statistical-minifs-function.html 来源：LearnFk无涯教程网	Required
criteria_range2, criteria2, ...	Additional ranges and their associated criteria. You can enter up to 126 range/criteria pairs.	Optional