{"id":130,"date":"2022-08-30T23:17:22","date_gmt":"2022-08-30T23:17:22","guid":{"rendered":"https:\/\/www.excelfinancemastery.com\/?p=12"},"modified":"2024-01-26T23:23:19","modified_gmt":"2024-01-26T23:23:19","slug":"excel-minifs-function","status":"publish","type":"post","link":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/","title":{"rendered":"How to use MINIFS in Excel"},"content":{"rendered":"<p>You&#8217;ll likely be familiar with the MIN function for taking the value of a range: <code>MIN(A1:A5)<\/code> will return the minimum value in cells <code>A1:A5<\/code>.\u00a0 If you need to take a conditional minimum, which applies to only some of the values in that range, without splitting your data up, then the Excel <code>MINIFS<\/code> function is what you&#8217;re looking for.\u00a0 This article is a complete guide to using the MINIFS function.<\/p>\n<p>There are lots of possible uses, but some examples of when you might want to use the <code>MINIFS<\/code> function are:<\/p>\n<ul>\n<li>Find the minimum value which to a particular type in another column in your data. For example, in a list of account balances, you might want to find the minimum of a particular type of account, rather than the minimum of all.<\/li>\n<li>Find the minimum value based on the values themselves. For example, the minimum of all positive account balances.<\/li>\n<\/ul>\n<p>It&#8217;s worth saying that, the Excel <code>MINIFS<\/code> function is only available in newer versions of Excel, such as Excel 2019 or Excel 365.\u00a0 If you are using an older version of Excel, a similar result is possible using an array formula, as we describe in the final section below: <a href=\"#conditional-min-older-excel\">Conditional Min in Older Versions of Excel<\/a>.<\/p>\n<p>We&#8217;ve created some dummy data to show how it works in the examples below, which we&#8217;ll refer back to.<\/p>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-14 size-full\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/08\/1.-minifs-data-e1661470827100.png\" alt=\"example example and uses of MINIFS\" width=\"500\" height=\"212\" \/><\/h2>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#Function_Fact_Sheet_MINIFS\" title=\"Function Fact Sheet: MINIFS\">Function Fact Sheet: MINIFS<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#Excel_Versions\" title=\"Excel Versions\">Excel Versions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#Description\" title=\"Description\">Description<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#Return_Value\" title=\"Return Value\">Return Value<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#Syntax\" title=\"Syntax\">Syntax<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#Arguments\" title=\"Arguments\">Arguments<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#Examples\" title=\"Examples\">Examples<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#MINIFS_with_Single_Criterion\" title=\"MINIFS with Single Criterion\">MINIFS with Single Criterion<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#MINIFS_with_Multiple_Criteria\" title=\"MINIFS with Multiple Criteria\">MINIFS with Multiple Criteria<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#MINIFS_with_Wildcards\" title=\"MINIFS with Wildcards\">MINIFS with Wildcards<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#MINIFS_with_Not_Equals_Criteria\" title=\"MINIFS with Not Equals Criteria\">MINIFS with Not Equals Criteria<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#MINIFS_where_cells_are_not_blank\" title=\"MINIFS where cells are not blank\">MINIFS where cells are not blank<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#MINIFS_using_a_value_from_another_cell\" title=\"MINIFS using a value from another cell\">MINIFS using a value from another cell<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#Conditional_MIN_in_Older_Versions_of_Excel\" title=\"Conditional MIN in Older Versions of Excel\">Conditional MIN in Older Versions of Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#References\" title=\"References\">References<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Function_Fact_Sheet_MINIFS\"><\/span>Function Fact Sheet: MINIFS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Excel_Versions\"><\/span>Excel Versions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This function is available in Excel 2019, Excel 365, or later.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Description\"><\/span>Description<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>MINIFS lets you specify a data range plus criteria ranges and values. It will return the minimum value in the data range, where the criteria are met. This works in a similar way to functions such as <code>SUMIFS<\/code>.<\/p>\n<p>For example, if your data is in range <code>A1:A5<\/code>, and your criteria are in <code>B1:B5<\/code>, then Excel will work out which values to take the min of by a process like the following:<\/p>\n<ul>\n<li>Does cell B1 meet the criteria?\u00a0 If so then include A1 in the calculation of the minimum, otherwise ignore it.<\/li>\n<li>Does cell B2 meet the criteria?\u00a0 If so then include A2 in the calculation of the minimum, otherwise ignore it.<\/li>\n<li>(and so on!)<\/li>\n<\/ul>\n<p>So for <code>MINIFS(A1:A5, B1:B5, \"criteria\")<\/code>, only cells B1 and B3 meet the criteria, then only A1 and A3 will be taken account in the calculation of the minimum, and it the value returned will be the same as <code>MIN(A1, A3)<\/code>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Return_Value\"><\/span>Return Value<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Returns the minimum value in the range, where the criteria are met.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Syntax\"><\/span>Syntax<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>For one criterion: <code>=MINIFS(min_range, criteria_range1, criteria1)<\/code><\/p>\n<p>Two or more criteria: <code>=MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Arguments\"><\/span>Arguments<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The MINIFS function is called with the following arguments:<\/p>\n<ul>\n<li><code>min_range<\/code> [Range]: The range of values you wish to find the minimum of<\/li>\n<li><code>criteria_range_1<\/code> [Range]: The range of cells which are compared with criteria1 argument. In cases where this satisfies the criteria, the values in min_range will be included in the minimum calculation. This can be the same range as min_range.<\/li>\n<li><code>criteria1 <\/code>[Value]: The criteria used for comparing the values in <code>criteria_range_1<\/code>. This can be a value, (e.g. 1000), text (&#8220;Insurance&#8221;), can contain logical statements (&#8220;&gt;1000&#8221;) and wildcards (&#8220;Ins*&#8221;).<\/li>\n<\/ul>\n<p>Optionally, you can include additional pairs of criteria_range \/ criteria arguments to apply other conditions.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Examples\"><\/span>Examples<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"MINIFS_with_Single_Criterion\"><\/span>MINIFS with Single Criterion<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In this section we look at some examples.\u00a0 One of the most straightforward uses is to calculate the minimum value in a range based on a single criterion.\u00a0 Using the example data above, we can calculate the minimum value (in range <code>C2:C7<\/code>) where the type (in <code>B2:B7<\/code>) is &#8220;Insurance&#8221;. We use absolute cell references by adding $ signs, so that the ranges wouldn&#8217;t be affected if the formula was copied elsewhere on the sheet, or filled down.<\/p>\n<p><code>=MINIFS($C$2:$C$7,$B$2:$B$7,\"Insurance\")<\/code><\/p>\n<p>As shown in the earlier screenshot, this would correctly return the value 500.<\/p>\n<p>Alternatively, it&#8217;s possible to use the values themselves as a criteria.\u00a0 For example, suppose we want to find the minimum positive value &#8211; we can do by specifying the range containing the values in both the <em>min_range<\/em> and <em>criteria_range<\/em> arguments:<\/p>\n<p><code>=MINIFS($C$2:$C$7,$C$2:$C$7,\"&gt;0\")<\/code><\/p>\n<p>With our example data, this correctly excludes the negative values and returns 300.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"MINIFS_with_Multiple_Criteria\"><\/span>MINIFS with Multiple Criteria<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>It&#8217;s also possible to combine multiple criteria and take the minimum where they both hold true &#8211; i.e. condition1 <strong>and<\/strong> condition2 are satisfied. Again using the example above, we can do this to find the minimum value where the value is positive and the contract type is &#8220;Savings&#8221;. For example, the following formula will return 300 based on our test data.<\/p>\n<p><code>=MINIFS($C$2:$C$7,$C$2:$C$7,\"&gt;0\",$B$2:$B$7,\"Savings\")<\/code><\/p>\n<p>As many additional criteria_range \/ criteria pairs as you need to the end of the formula.<\/p>\n<p>The above will give the minimum if both criteria pass.\u00a0 To find the minimum if either criteria pass (i.e. condition1 <strong>or<\/strong> condition2), we need to take a slightly different approach and take the minimum of the separate results, for example:<\/p>\n<p><code>=MIN(MINIFS($C$2:$C$7,$C$2:$C$7,\"&gt;0\"), MINIFS($C$2:$C$7,$B$2:$B$7,\"Savings\"))<\/code><\/p>\n<p>Just to explain what this is doing, we can split it up as follows:<\/p>\n<ul>\n<li><code>MINIFS($C$2:$C$7,$C$2:$C$7,\"&gt;0\")<\/code> is the minimum of positive values (300)<\/li>\n<li><code>MINIFS($C$2:$C$7,$B$2:$B$7,\"Savings\")<\/code> is the minimum of Savings account values (-50)<\/li>\n<li>Putting these values in, the formula simplifies to <code>=MIN(300, -50)<\/code>, taking the lowest of these two values, which is -50.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"MINIFS_with_Wildcards\"><\/span>MINIFS with Wildcards<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>As with formulas like SUMIFS, it is possible to use wildcards in the MINIFS formula. The wildcards available in Excel are:<\/p>\n<ul>\n<li><code>*<\/code> (asterisk) &#8211; match any number of other characters, e.g. the criteria &#8220;www.*.com&#8221; would match both &#8220;www.google.com&#8221; and &#8220;www.microsoft.com&#8221;, but not &#8220;example.com&#8221; (which doesn&#8217;t start with www).<\/li>\n<li><code>?<\/code> (question mark) &#8211; match a single character, e.g. &#8220;Policy?&#8221; would match &#8220;Policy1&#8221; or &#8220;Policy9&#8221; but not &#8220;Policy10&#8221; (which was two extra characters.<\/li>\n<li><code>~<\/code> (tilde) &#8211; used to match one of the wildcard characters in text, e.g. without this, the criteria &#8220;Why?&#8221; would match &#8220;Why?&#8221;, &#8220;Why1&#8221;, &#8220;WhyX&#8221;. If we just want to match the question &#8220;Why?&#8221;, we use the criteria &#8220;Why~?&#8221;<\/li>\n<\/ul>\n<p>Some examples of MINIFS using these criteria are as follows (these don&#8217;t exactly correspond to the data above, but could be useful if the data was more complex than our simple example):<\/p>\n<ul>\n<li>To find the minimum where account number (in <code>A2:A7<\/code>) starts with X <code>=MINIFS($C$2:$C$7,$A$2:$A$7,\"X*\")<\/code><\/li>\n<li>For the minimum where product type is, for example, &#8220;Insurance1&#8221;, &#8220;Insurance2&#8221;, etc (but not just &#8220;Insurance&#8221;): <code>=MINIFS($C$2:$C$7,$B$2:$B$7,\"Insurance?\")<\/code><\/li>\n<li>And the minimum where product type is the exact text &#8220;Insurance?&#8221; (e.g. who ever was entering data has guessed about the account type): <code>=MINIFS($C$2:$C$7,$B$2:$B$7,\"Insurance?\")<\/code><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"MINIFS_with_Not_Equals_Criteria\"><\/span>MINIFS with Not Equals Criteria<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In the above examples, we&#8217;ve been testing for matches to the criteria we gave. It&#8217;s also possible to turn it round and find the minimum where the criteria_range is not equal to some value. As an example, we can rewrite our earlier example to find the minimum Insurance contract value by specifying that it is not a Savings contract instead. Do to this we use the &lt;&gt; not equal to operator:<\/p>\n<p><code>=MINIFS($C$2:$C$7,$B$2:$B$7,\"&lt;&gt;Savings\")<\/code><\/p>\n<p>This returns the minimum of all values where the account type is not &#8220;Savings&#8221;. In our simple example with only two account types this gives the value 500, which was the same as in the earlier example looking for the minimum &#8220;Insurance&#8221; account value. However, in real data with several account types, we could use this to find the minimum excluding a particular type.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"MINIFS_where_cells_are_not_blank\"><\/span>MINIFS where cells are not blank<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Another usage might be to find the minimum value where the corresponding cells in a different range are not blank (i.e. ignore the blank cells). To do this, you can simply enter the criteria_value as &#8220;&lt;&gt;&#8221;, for example, to exclude blank entries in our example above (there aren&#8217;t any in the data shown though), the formula would be:<\/p>\n<p>=MINIFS($C$2:$C$7,$B$2:$B$7,&#8221;&lt;&gt;&#8221;)<\/p>\n<p>Another case might be where the values themselves contain some blank cells. In this case, the MIN() function would actually ignore the blank cells and return the minimum of the other values, but you can achieve the same result with MINIFS as follows by entering the same range for both value_range and criteria_range, and then specifying not blank:<\/p>\n<p>=MINIFS($C$2:$C$7,$C$2:$C$7,&#8221;&lt;&gt;&#8221;)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"MINIFS_using_a_value_from_another_cell\"><\/span>MINIFS using a value from another cell<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Typing in the criteria each time will get tiring! And will be impossible if you have a large range of values, or if you don&#8217;t know what these might be when building the spreadsheet. You can automate this by using the value from a different cell in the criteria range &#8211; just type the address of the cell containing the criteria in that argument, e.g. &#8220;$B10&#8221;:<\/p>\n<p>=MINIFS($C$2:$C$7,$B$2:$B$7,$B10)<\/p>\n<p>You can use this to build up tables of minima by filling down, as shown in the example below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-24 size-full\" src=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/08\/2.-minifs-table-e1661901946906.png\" alt=\"Example showing MINIFS formula examples where the criteria_value is another cell on the workbook.\" width=\"501\" height=\"299\" \/><\/p>\n<p>As show above, this also lets you put conditional statements (e.g. &#8220;&gt;0&#8221;) and wildcards (&#8220;Ins*&#8221;) in those cells, and works just as if you had entered them directly in the formula.<\/p>\n<h2 id=\"conditional-min-older-excel\"><span class=\"ez-toc-section\" id=\"Conditional_MIN_in_Older_Versions_of_Excel\"><\/span>Conditional MIN in Older Versions of Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>It&#8217;s great if you have Excel 2019 or later and can use the MINIFS function. However, in some cases you won&#8217;t have this version. Particularly in a corporate environment where there is often a lag updating to the latest software versions. As I write this in 2022, I have one work environment where I need to use Excel 2010! This means that spreadsheets developed in the more recent version have to be backwards compatible so can&#8217;t take advantage of new formulas.<\/p>\n<p>If that&#8217;s the case, then you can achieve a similar result to MINIFS using MIN with array formula.\u00a0 Using the example data above, we can re-write this as an array formula as follows.\u00a0 Remember when entering an array formula to press SHIFT + ENTER after typing the formula in, otherwise it may not behave as expected.<\/p>\n<p>To find the minimum insurance account number (i.e. minimum of C2:C7 where B2:B7 equals &#8220;Insurance&#8221;):<\/p>\n<ul>\n<li>MINIFS version: <code>=MINIFS($C$2:$C$7,$B$2:$B$7,\"Insurance\")<\/code><\/li>\n<li>Array formula: <code>=MIN(IF($B$2:$B$7=\"Insurance\",$C$2:$C$7,\"\"))<\/code><\/li>\n<\/ul>\n<p>To find the minimum positive account balance (i.e. minimum of C2:C7 where those values are greater than zero):<\/p>\n<ul>\n<li>MINIFS version: <code>=MINIFS($C$2:$C$7,$C$2:$C$7,\"&gt;0\")<\/code><\/li>\n<li>Array formula: <code>=MIN(IF($C$2:$C$7&gt;0,$C$2:$C$7,\"\"))<\/code><\/li>\n<\/ul>\n<p>In these cases, we are replacing the values which do not meet our criteria with an empty string value (&#8220;&#8221;), which is then ignored by MIN(), so that only those values which meet our criteria are included.<\/p>\n<p>It&#8217;s also possible to specify multiple criteria, but unfortunately the AND function doesn&#8217;t work as you might think in array formulas (it only returns a single value rather than an array), so we have to build this up as a series of nested IF functions.<\/p>\n<p>With our example, to find the minimum positive account balance of insurance contracts, we could do:<\/p>\n<ul>\n<li>MINIFS version:<code> =MINIFS($C$2:$C$7,$C$2:$C$7,\"&gt;0\",$B$2:$B$7,\"Insurance\")<\/code><\/li>\n<li>Array formula: <code>=MIN(IF($C$2:$C$7&gt;0,IF($B$2:$B$7=\"Insurance\",$C$2:$C$7,\"\"),\"\"))<\/code><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"References\"><\/span>References<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599\">Microsoft documentation on MINIFS function<\/a>.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>You&#8217;ll likely be familiar with the MIN function for taking the value of a range: MIN(A1:A5) will return the minimum value in cells A1:A5.\u00a0 If you need to take a conditional minimum, which applies to only some of the values in that range, without splitting your data up, then the Excel MINIFS function is what &#8230; <a title=\"How to use MINIFS in Excel\" class=\"read-more\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/\" aria-label=\"More on How to use MINIFS in Excel\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to use MINIFS in Excel - Tiposaurus<\/title>\n<meta name=\"description\" content=\"A complete guide to using the MINIFS function in Excel to calculate the conditional minimum of a range of values, with examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use MINIFS in Excel - Tiposaurus\" \/>\n<meta property=\"og:description\" content=\"A complete guide to using the MINIFS function in Excel to calculate the conditional minimum of a range of values, with examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/\" \/>\n<meta property=\"og:site_name\" content=\"Tiposaurus\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-30T23:17:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-26T23:23:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/08\/1.-minifs-data-e1661470827100.png\" \/>\n<meta name=\"author\" content=\"Steven\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Steven\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/\"},\"author\":{\"name\":\"Steven\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c\"},\"headline\":\"How to use MINIFS in Excel\",\"datePublished\":\"2022-08-30T23:17:22+00:00\",\"dateModified\":\"2024-01-26T23:23:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/\"},\"wordCount\":1729,\"publisher\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\"},\"articleSection\":[\"Functions\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/\",\"name\":\"How to use MINIFS in Excel - Tiposaurus\",\"isPartOf\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#website\"},\"datePublished\":\"2022-08-30T23:17:22+00:00\",\"dateModified\":\"2024-01-26T23:23:19+00:00\",\"description\":\"A complete guide to using the MINIFS function in Excel to calculate the conditional minimum of a range of values, with examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tiposaurus.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use MINIFS in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#website\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/\",\"name\":\"Tiposaurus\",\"description\":\"Technology, Productivity and Development\",\"publisher\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tiposaurus.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\",\"name\":\"Tiposaurus\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png\",\"contentUrl\":\"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png\",\"width\":133,\"height\":97,\"caption\":\"Tiposaurus\"},\"image\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c\",\"name\":\"Steven\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g\",\"caption\":\"Steven\"},\"sameAs\":[\"https:\/\/www.tiposaurus.co.uk\"],\"url\":\"https:\/\/www.tiposaurus.co.uk\/author\/steven\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to use MINIFS in Excel - Tiposaurus","description":"A complete guide to using the MINIFS function in Excel to calculate the conditional minimum of a range of values, with examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/","og_locale":"en_GB","og_type":"article","og_title":"How to use MINIFS in Excel - Tiposaurus","og_description":"A complete guide to using the MINIFS function in Excel to calculate the conditional minimum of a range of values, with examples.","og_url":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/","og_site_name":"Tiposaurus","article_published_time":"2022-08-30T23:17:22+00:00","article_modified_time":"2024-01-26T23:23:19+00:00","og_image":[{"url":"https:\/\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/08\/1.-minifs-data-e1661470827100.png"}],"author":"Steven","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Steven","Estimated reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#article","isPartOf":{"@id":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/"},"author":{"name":"Steven","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c"},"headline":"How to use MINIFS in Excel","datePublished":"2022-08-30T23:17:22+00:00","dateModified":"2024-01-26T23:23:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/"},"wordCount":1729,"publisher":{"@id":"https:\/\/www.tiposaurus.co.uk\/#organization"},"articleSection":["Functions"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/","url":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/","name":"How to use MINIFS in Excel - Tiposaurus","isPartOf":{"@id":"https:\/\/www.tiposaurus.co.uk\/#website"},"datePublished":"2022-08-30T23:17:22+00:00","dateModified":"2024-01-26T23:23:19+00:00","description":"A complete guide to using the MINIFS function in Excel to calculate the conditional minimum of a range of values, with examples.","breadcrumb":{"@id":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tiposaurus.co.uk\/"},{"@type":"ListItem","position":2,"name":"How to use MINIFS in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.tiposaurus.co.uk\/#website","url":"https:\/\/www.tiposaurus.co.uk\/","name":"Tiposaurus","description":"Technology, Productivity and Development","publisher":{"@id":"https:\/\/www.tiposaurus.co.uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tiposaurus.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.tiposaurus.co.uk\/#organization","name":"Tiposaurus","url":"https:\/\/www.tiposaurus.co.uk\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/","url":"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png","contentUrl":"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png","width":133,"height":97,"caption":"Tiposaurus"},"image":{"@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c","name":"Steven","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g","caption":"Steven"},"sameAs":["https:\/\/www.tiposaurus.co.uk"],"url":"https:\/\/www.tiposaurus.co.uk\/author\/steven\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":132,"url":"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/","url_meta":{"origin":130,"position":0},"title":"How to use MAXIFS in Excel","author":"Steven","date":"March 20, 2023","format":false,"excerpt":"MAXIFS is a function in Excel that allows you to find the maximum value in a range that meets specific criteria. It's an extremely useful function when dealing with large sets of data, as it allows you to quickly and easily identify the highest value that meets certain conditions. This\u2026","rel":"","context":"In &quot;Functions&quot;","block_context":{"text":"Functions","link":"https:\/\/www.tiposaurus.co.uk\/category\/functions\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":135,"url":"https:\/\/www.tiposaurus.co.uk\/how-to-calculate-net-present-values-in-excel\/","url_meta":{"origin":130,"position":1},"title":"How to Calculate Net Present Values in Excel","author":"Steven","date":"April 11, 2023","format":false,"excerpt":"Introduction Net Present Value (NPV) is a widely used financial metric that helps investors and business managers to evaluate the profitability of an investment or project. NPV calculates the difference between the present value of cash inflows and the present value of cash outflows over a certain period. A positive\u2026","rel":"","context":"In &quot;Excel&quot;","block_context":{"text":"Excel","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/excel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":133,"url":"https:\/\/www.tiposaurus.co.uk\/5-excel-formulas-every-finance-professional-should-know\/","url_meta":{"origin":130,"position":2},"title":"5 Excel Formulas Every Finance Professional Should Know","author":"Steven","date":"April 10, 2023","format":false,"excerpt":"The Importance of Excel in Finance As a finance professional, you already know that Excel is an essential tool in your day-to-day work. It's a powerful software that allows for efficient data manipulation, analysis, and reporting. The true magic of Excel lies in its formulas, which can help you automate\u2026","rel":"","context":"In &quot;Functions&quot;","block_context":{"text":"Functions","link":"https:\/\/www.tiposaurus.co.uk\/category\/functions\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":58,"url":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/","url_meta":{"origin":130,"position":3},"title":"Display the Weekday as Text in Excel","author":"Steven","date":"September 19, 2022","format":false,"excerpt":"I often want to know what day of the week a date is. The obvious choice in Excel is the WEEKDAY() function for this; however it only returns an integer. For example, the formula: =WEEKDAY(\"01\/02\/2009\") returns 1 (which represents Sunday). In this article, I'll describe the various ways which you\u2026","rel":"","context":"In &quot;Excel&quot;","block_context":{"text":"Excel","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/excel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":134,"url":"https:\/\/www.tiposaurus.co.uk\/excel-tips-and-tricks-for-financial-modeling\/","url_meta":{"origin":130,"position":4},"title":"Excel Tips and Tricks for Financial Modeling","author":"Steven","date":"April 10, 2023","format":false,"excerpt":"Financial modeling is an essential skill for finance professionals, allowing them to project financial performance, evaluate investment opportunities, and make informed decisions. Microsoft Excel is the go-to software for building financial models, thanks to its flexibility, functionality, and ease of use. In this blog post, we'll share tips and tricks\u2026","rel":"","context":"In &quot;Excel&quot;","block_context":{"text":"Excel","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/excel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":71,"url":"https:\/\/www.tiposaurus.co.uk\/the-dictionary-object-in-excel-vba-definitive-guide\/","url_meta":{"origin":130,"position":5},"title":"The Dictionary Object in Excel VBA &#8211; Definitive Guide","author":"Steven","date":"April 11, 2023","format":false,"excerpt":"1. Introduction This guide aims to provide a comprehensive understanding of the Dictionary object in Excel VBA, including an overview of its features and the advantages it offers over other data structures like arrays and collections. We will also cover how to include the necessary library, create a dictionary, add\u2026","rel":"","context":"In &quot;VBA&quot;","block_context":{"text":"VBA","link":"https:\/\/www.tiposaurus.co.uk\/category\/vba\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/130"}],"collection":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":1,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":155,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/130\/revisions\/155"}],"wp:attachment":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}