MINIFS

Returns the minimum value in a range of cells, filtered by a set of criteria. Learn more.

Video field
Statistical

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.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!