SheetFX
≡
<< Go back to all functions

MINIFS

The MINIFS function in Google Sheets is a useful tool for finding the minimum value in a range of cells, filtered by a set of criteria. This function allows you to narrow down your data and extract the smallest value based on specific conditions. Take a deep dive into our comprehensive guide to understand its syntax and master its application.

Function Syntax and Parameters

Syntax: MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], ...)

Parameters:

  • range: The range of cells to evaluate for the minimum value.
  • criteria_range1: The range of cells to be evaluated for the first criterion.
  • criterion1: The condition or criteria that must be met in the first criteria range.
  • [criteria_range2, criterion2, …] (optional): Additional ranges and criteria to consider.

Step-by-Step Tutorial

  1. Using MINIFS with a single criteria range and criterion:

    • Example: =MINIFS(A1:A5, B1:B5, ">5")
    • Result: Returns the minimum value from cells A1 to A5 that meets the condition that the corresponding cells in B1 to B5 are greater than 5.

  2. Using MINIFS with multiple criteria ranges and criteria:

    • Example: =MINIFS(A1:A5, B1:B5, ">5", C1:C5, "<10")
    • Result: Finds the minimum value from cells A1 to A5 that satisfies the condition that the corresponding cells in B1 to B5 are greater than 5 and the corresponding cells in C1 to C5 are less than 10.

Use Cases and Scenarios

  1. Sales Analysis: Determine the minimum sales figure for a specific product category within a given time frame.
  2. Financial Planning: Find the minimum expense incurred on a particular day or during a specific month.
  3. Academic Performance: Identify the lowest grade achieved by students in a particular subject.

Related Functions

  • MIN: Get the minimum value from a set of numbers or cells.
  • MINA: Find the smallest value among a set, including text and other data types.

Related Articles