Returns the minimum value in a range of cells, filtered by a set of criteria. Learn more.
The MINIFS function is a function in Google Sheets that allows you to find the minimum value in a range of cells that meets specific criteria.
It is similar to the MIN function, but with the added capability of applying multiple criteria.
The syntax of the MINIFS function is as follows:
MINIFS(range, criteriarange1, criterion1, [criteriarange2, criterion2, …])
range refers to the range of cells you want to evaluate and find the minimum value from.
criteria_range1 is the range of cells where the first criterion is applied.
criterion1 is the condition or value that the cells in criteria_range1 must meet in order to be considered for the minimum calculation.
[criteria_range2, criterion2, …] are optional additional ranges and criteria that can be specified.
You can use up to 127 pairs of criteria_range and criterion in the MINIFS function. The function will find the minimum value in the specified range that meets all the specified criteria.
Here's an example to help illustrate the usage of the MINIFS function:
=MINIFS(A1:A10, B1:B10, ">10", C1:C10, "<>0")
In this example, the function will find the minimum value in the range A1:A10,
but only consider the values where the corresponding cells in range B1:B10 are greater than 10 and the cells in range C1:C10 are not equal to 0.