{"id":132,"date":"2023-03-20T00:33:57","date_gmt":"2023-03-20T00:33:57","guid":{"rendered":"https:\/\/www.excelfinancemastery.com\/?p=61"},"modified":"2024-01-26T23:22:34","modified_gmt":"2024-01-26T23:22:34","slug":"how-to-use-maxifs-in-excel","status":"publish","type":"post","link":"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/","title":{"rendered":"How to use MAXIFS in Excel"},"content":{"rendered":"<p>MAXIFS is a function in Excel that allows you to find the maximum value in a range that meets specific criteria. It&#8217;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 is similar to <a href=\"https:\/\/www.excelfinancemastery.com\/excel-minifs-function\/\">MINIFS<\/a> which allows you to identify the lowest value which meets certain conditions. In this tutorial, we&#8217;ll go over the different ways you can use MAXIFS in Excel, including examples with multiple criteria, wildcards, not equals criteria, and not blank cells.<\/p>\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 ' ><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/#Function_Fact_Sheet_MAXIFS\" title=\"Function Fact Sheet: MAXIFS\">Function Fact Sheet: MAXIFS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/#Using_MAXIFS_with_multiple_criteria\" title=\"Using MAXIFS with multiple criteria\">Using MAXIFS with multiple criteria<\/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\/how-to-use-maxifs-in-excel\/#Using_MAXIFS_with_wildcards\" title=\"Using MAXIFS with wildcards\">Using MAXIFS with wildcards<\/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\/how-to-use-maxifs-in-excel\/#Using_MAXIFS_with_not_equals_criteria\" title=\"Using MAXIFS with not equals criteria\">Using MAXIFS 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-5\" href=\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/#Using_MAXIFS_with_not_blank_criteria\" title=\"Using MAXIFS with not blank criteria\">Using MAXIFS with not blank criteria<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/#Conditional_MAXin_Older_Versions_of_Excel\" title=\"Conditional MAXin Older Versions of Excel\">Conditional MAXin Older Versions of Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Function_Fact_Sheet_MAXIFS\"><\/span>Function Fact Sheet: MAXIFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Before we dive into the different examples, let&#8217;s first review the basic syntax for the MAXIFS function:<\/p>\n<p><code>MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)<\/code><\/p>\n<ul>\n<li><code>max_range<\/code>: This is the range of cells that you want to find the maximum value in.<\/li>\n<li><code>criteria_range1<\/code>: This is the range of cells that you want to apply the first criteria to.<\/li>\n<li><code>criteria1<\/code>: This is the first criteria that you want to apply to the first criteria range.<\/li>\n<li><code>[criteria_range2, criteria2]<\/code>: These are optional additional criteria ranges and criteria that you want to apply to them.<\/li>\n<\/ul>\n<p>Now that we understand the basic syntax for MAXIFS, let&#8217;s move on to the different examples for usage.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Using_MAXIFS_with_multiple_criteria\"><\/span>Using MAXIFS with multiple criteria<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>One of the most powerful features of the MAXIFS function is the ability to use multiple criteria. This allows you to find the maximum value that meets more than one condition. For example, let&#8217;s say you have a table of sales data and you want to find the highest sales amount for a specific product in a specific month. Here&#8217;s how you would do it:<\/p>\n<p>First, select the cell where you want to display the maximum value. Then, type &#8220;=&#8221; to start the formula. Next, type &#8220;MAXIFS(&#8221; to start the MAXIFS function.<\/p>\n<p>Now, select the range of cells that contains the sales amounts (max_range), and type a comma to move to the next argument.<\/p>\n<p>Next, select the range of cells that contains the months (criteria_range1), and type a comma to move to the next argument.<\/p>\n<p>Type the month you want to search for (criteria1), surrounded by quotes. For example, if you want to find the highest sales amount for January, you would type &#8220;January&#8221;.<\/p>\n<p>Type another comma to move to the next argument. Now, select the range of cells that contains the products (criteria_range2), and type another comma to move to the next argument.<\/p>\n<p>Finally, type the name of the product you want to search for (criteria2), surrounded by quotes. For example, if you want to find the highest sales amount for the product &#8220;Widget A&#8221; in January, you would type &#8220;Widget A&#8221;.<\/p>\n<p>The complete formula would look like this:<\/p>\n<p><code>=MAXIFS(B2:B10, A2:A10, \"January\", C2:C10, \"Widget A\")<\/code><\/p>\n<p>Press enter to calculate the result, and the cell will display the highest sales amount for the product &#8220;Widget A&#8221; in January.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Using_MAXIFS_with_wildcards\"><\/span>Using MAXIFS with wildcards<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Another powerful feature of the MAXIFS function is the ability to use wildcards. Wildcards are symbols that represent any character or group of characters, and they can be used to match a pattern in a text string. This allows you to search for values that match a certain pattern, even if you don&#8217;t know the exact value you&#8217;re looking for.<\/p>\n<p>For example, let&#8217;s say you have a table of employee data and you want to find the highest salary for all employees whose job title contains the word &#8220;Manager&#8221;. Here&#8217;s how you would do it:<\/p>\n<p>First, select the cell where you want to display the maximum value. Then, type &#8220;=&#8221; to start the formula. Next, type &#8220;MAXIFS(&#8221; to start the MAXIFS function.<\/p>\n<p>Now, select the range of cells that contains the salaries (max_range), and type a comma to move to the next argument.<\/p>\n<p>Next, select the range of cells that contains the job titles (criteria_range1), and type a comma to move to the next argument.<\/p>\n<p>Type the criteria you want to search for (criteria1), using a wildcard asterisk (*) to represent any characters before or after the word &#8220;Manager&#8221;, i.e. &#8220;*Manager*&#8221;. For example, this would match job titles such as &#8220;Project-Manager&#8221; and &#8220;Manager of People&#8221;.<\/p>\n<p>The complete formula would look like this:<\/p>\n<p><code>=MAXIFS(B2:B10, A2:A10, \"*<em>Manager*<\/em>\")<\/code><\/p>\n<p>Press enter to calculate the result, and the cell will display the highest salary for all employees whose job title contains the word &#8220;Manager&#8221;.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Using_MAXIFS_with_not_equals_criteria\"><\/span>Using MAXIFS with not equals criteria<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In some cases, you may want to find the maximum value that does not meet a certain criteria. For example, let&#8217;s say you have a table of test scores and you want to find the highest score that is not an A. Here&#8217;s how you would do it:<\/p>\n<p>First, select the cell where you want to display the maximum value. Then, type &#8220;=&#8221; to start the formula. Next, type &#8220;MAXIFS(&#8221; to start the MAXIFS function.<\/p>\n<p>Now, select the range of cells that contains the test scores (max_range), and type a comma to move to the next argument.<\/p>\n<p>Next, select the range of cells that contains the grade letters (criteria_range1), and type a comma to move to the next argument.<\/p>\n<p>Type the criteria you want to exclude (criteria1), using the not equals operator (&lt;&gt;). For example, if you want to exclude all A grades, you would type &#8220;&lt;&gt;A&#8221;.<\/p>\n<p>The complete formula would look like this:<\/p>\n<p><code>=MAXIFS(B2:B10, A2:A10, \"&lt;&gt;A\")<\/code><\/p>\n<p>Press enter to calculate the result, and the cell will display the highest score that is not an A.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Using_MAXIFS_with_not_blank_criteria\"><\/span>Using MAXIFS with not blank criteria<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Finally, you can also use the MAXIFS function to find the highest value in a range that is not blank. This can be useful when dealing with data that has missing values. For example, let&#8217;s say you have a table of product prices and you want to find the highest price that is not blank. Here&#8217;s how you would do it:<\/p>\n<p>First, select the cell where you want to display the maximum value. Then, type &#8220;=&#8221; to start the formula. Next, type &#8220;MAXIFS(&#8221; to start the MAXIFS function.<\/p>\n<p>Now, select the range of cells that contains the product prices (max_range), and type a comma to move to the next argument.<\/p>\n<p>Next, select the same range of cells as the criteria range (criteria_range1), and type a comma to move to the next argument.<\/p>\n<p>Type the criteria you want to apply (criteria1), using the not equal to operator (&lt;&gt;). For example, if you want to exclude all blank cells, you would type &#8220;&lt;&gt;&#8221;.<\/p>\n<p>The complete formula would look like this:<\/p>\n<p><code>=MAXIFS(B2:B10, B2:B10, \"&lt;&gt;\")<\/code><\/p>\n<p>Press enter to calculate the result, and the cell will display the highest price that is not blank.<\/p>\n<h2 id=\"conditional-min-older-excel\"><span class=\"ez-toc-section\" id=\"Conditional_MAXin_Older_Versions_of_Excel\"><\/span>Conditional MAXin 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 MAXIFS 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 2023. 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 MAXIFS using MAX with array formula.\u00a0 Using the example data above, we can rewrite 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 maximum insurance account number (i.e. maximum of C2:C7 where B2:B7 equals &#8220;Insurance&#8221;):<\/p>\n<ul>\n<li>MAXIFS version: <code>=MAXIFS($C$2:$C$7,$B$2:$B$7,\"Insurance\")<\/code><\/li>\n<li>Array formula: <code>=MAX(IF($B$2:$B$7=\"Insurance\",$C$2:$C$7,\"\"))<\/code><\/li>\n<\/ul>\n<p>To find the maximum positive account balance (i.e. maximum of C2:C7 where those values are greater than zero):<\/p>\n<ul>\n<li>MAXIFS version: <code>=MAXIFS($C$2:$C$7,$C$2:$C$7,\"&gt;0\")<\/code><\/li>\n<li>Array formula: <code>=MAX(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 MAX(), 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 maximum positive account balance of insurance contracts, we could do:<\/p>\n<ul>\n<li>MAXIFS version:<code> =MAXIFS($C$2:$C$7,$C$2:$C$7,\"&gt;0\",$B$2:$B$7,\"Insurance\")<\/code><\/li>\n<li>Array formula: <code>=MAX(IF($C$2:$C$7&gt;0,IF($B$2:$B$7=\"Insurance\",$C$2:$C$7,\"\"),\"\"))<\/code><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In conclusion, the MAXIFS function is a powerful tool in Excel that allows you to find the maximum value in a range that meets specific criteria. By using multiple criteria, wildcards, not equals criteria, and not blank cells, you can easily analyze and make sense of large sets of data. With the examples provided in this tutorial, you should be able to apply the MAXIFS function to your own data and start getting insights right away. We&#8217;ve also shown a method to achieve the same results as MAXIFS on earlier versions of Excel by using array formulas.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MAXIFS is a function in Excel that allows you to find the maximum value in a range that meets specific criteria. It&#8217;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 is similar to MINIFS which &#8230; <a title=\"How to use MAXIFS in Excel\" class=\"read-more\" href=\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/\" aria-label=\"More on How to use MAXIFS 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 MAXIFS in Excel - Tiposaurus<\/title>\n<meta name=\"description\" content=\"A complete guide to using the MAXIFS function in Excel to calculate the conditional maximum 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\/how-to-use-maxifs-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use MAXIFS in Excel - Tiposaurus\" \/>\n<meta property=\"og:description\" content=\"A complete guide to using the MAXIFS function in Excel to calculate the conditional maximum of a range of values, with examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tiposaurus\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-20T00:33:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-26T23:22:34+00:00\" \/>\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=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/\"},\"author\":{\"name\":\"Steven\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c\"},\"headline\":\"How to use MAXIFS in Excel\",\"datePublished\":\"2023-03-20T00:33:57+00:00\",\"dateModified\":\"2024-01-26T23:22:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/\"},\"wordCount\":1471,\"publisher\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\"},\"articleSection\":[\"Functions\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/\",\"name\":\"How to use MAXIFS in Excel - Tiposaurus\",\"isPartOf\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#website\"},\"datePublished\":\"2023-03-20T00:33:57+00:00\",\"dateModified\":\"2024-01-26T23:22:34+00:00\",\"description\":\"A complete guide to using the MAXIFS function in Excel to calculate the conditional maximum of a range of values, with examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tiposaurus.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use MAXIFS 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 MAXIFS in Excel - Tiposaurus","description":"A complete guide to using the MAXIFS function in Excel to calculate the conditional maximum 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\/how-to-use-maxifs-in-excel\/","og_locale":"en_GB","og_type":"article","og_title":"How to use MAXIFS in Excel - Tiposaurus","og_description":"A complete guide to using the MAXIFS function in Excel to calculate the conditional maximum of a range of values, with examples.","og_url":"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/","og_site_name":"Tiposaurus","article_published_time":"2023-03-20T00:33:57+00:00","article_modified_time":"2024-01-26T23:22:34+00:00","author":"Steven","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Steven","Estimated reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/"},"author":{"name":"Steven","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c"},"headline":"How to use MAXIFS in Excel","datePublished":"2023-03-20T00:33:57+00:00","dateModified":"2024-01-26T23:22:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/"},"wordCount":1471,"publisher":{"@id":"https:\/\/www.tiposaurus.co.uk\/#organization"},"articleSection":["Functions"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/","url":"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/","name":"How to use MAXIFS in Excel - Tiposaurus","isPartOf":{"@id":"https:\/\/www.tiposaurus.co.uk\/#website"},"datePublished":"2023-03-20T00:33:57+00:00","dateModified":"2024-01-26T23:22:34+00:00","description":"A complete guide to using the MAXIFS function in Excel to calculate the conditional maximum of a range of values, with examples.","breadcrumb":{"@id":"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tiposaurus.co.uk\/"},{"@type":"ListItem","position":2,"name":"How to use MAXIFS 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":130,"url":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/","url_meta":{"origin":132,"position":0},"title":"How to use MINIFS in Excel","author":"Steven","date":"August 30, 2022","format":false,"excerpt":"You'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\u2026","rel":"","context":"In &quot;Functions&quot;","block_context":{"text":"Functions","link":"https:\/\/www.tiposaurus.co.uk\/category\/functions\/"},"img":{"alt_text":"example example and uses of MINIFS","src":"https:\/\/i0.wp.com\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/08\/1.-minifs-data-e1661470827100.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":133,"url":"https:\/\/www.tiposaurus.co.uk\/5-excel-formulas-every-finance-professional-should-know\/","url_meta":{"origin":132,"position":1},"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":134,"url":"https:\/\/www.tiposaurus.co.uk\/excel-tips-and-tricks-for-financial-modeling\/","url_meta":{"origin":132,"position":2},"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":135,"url":"https:\/\/www.tiposaurus.co.uk\/how-to-calculate-net-present-values-in-excel\/","url_meta":{"origin":132,"position":3},"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":58,"url":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/","url_meta":{"origin":132,"position":4},"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":71,"url":"https:\/\/www.tiposaurus.co.uk\/the-dictionary-object-in-excel-vba-definitive-guide\/","url_meta":{"origin":132,"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\/132"}],"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=132"}],"version-history":[{"count":1,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/132\/revisions"}],"predecessor-version":[{"id":153,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/132\/revisions\/153"}],"wp:attachment":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/media?parent=132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/categories?post=132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/tags?post=132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}