From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

How To Use MINIFS function in MS Excel With Examples

What is MINIF function in Excel?

The MINIF function in Excel searches for the smallest number in a range of cells that meet certain criteria. Function quickly finds the minimum value in a range of data based on specific criteria. It is similar to the MIN function, but with the added ability to specify criteria for the values to include in the calculation.

Description

The MINIF function MS Excel is a function for analyzing data. It allows you to quickly identify the minimum value from a range of cells based on criteria you specify.

For example, you can use the MINIF function to find the lowest temperature in a range of cells that match a certain city name. It’s an efficient way of quickly finding the lowest value from a range of cells based on criteria you set. The MINIF function is also useful for finding the lowest scores on a test, the lowest prices in a range of products, or the lowest sales in a given period. It’s an incredibly useful tool for data analysis.

Struggling with your Excel formulas?
Looking for a faster and easier way to write Excel formulas? Try AI Excel Formula Generator and turn your text into formulas with just a few clicks.

Try for free

Syntax

=MINIF(range, criteria, [sum_range])

This function calculates the minimum value in a range that meets a given criteria.

Syntax: =MINIF(range, criteria, [sum_range])

Parameters:

  • range – The range of cells that you want evaluate.
  • criteria – The criteria in the form of a number, expression, cell reference, or text that defines which cells will be used to find the minimum value.
  • sum_range (optional) – The cells to sum, if different from the range argument.

How to use MINIF function MS Excel in your workbook:

  1. Open the Excel spreadsheet you want to use the minif function in.
  2. Select a cell where you want the minif function results to appear.
  3. Type “=MINIF(” into the selected cell.
  4. Select the range of cells you want to evaluate.
  5. Type a comma after the range of cells.
  6. Type the criteria you want to use to evaluate the range of cells.
  7. Type a comma after the criteria.
  8. Select the range of cells you want to return the minimum value from.
  9. Type a closing parenthesis “)” after the range of cells.
  10. Press the “Enter” key on your keyboard. The minif function will calculate the minimum value from the range of cells based on the criteria you provided.

More similar functions and formulas

Read latest blog articles about Excel

WEEKLY BLOG ARTICLES WITH INDUSTRY NEWS AND HELPFUL GUIDES

How To Add Drop Down List in Excel

How To Add Drop Down List in Excel

Continue reading

How To Add Checkboxes In Excel

How To Add Checkboxes In Excel

Continue reading