{"id":6122,"date":"2025-08-05T13:20:15","date_gmt":"2025-08-05T13:20:15","guid":{"rendered":"https:\/\/www.repairmsexcel.com\/blog\/?p=6122"},"modified":"2025-08-07T07:15:41","modified_gmt":"2025-08-07T07:15:41","slug":"how-to-use-maxifs-in-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel","title":{"rendered":"Uncover the Secrets: How to Use MAXIFS in Excel?"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">In Microsoft Excel, <strong>MAXIFS<\/strong> is an excellent function that helps to find the largest value in the range that meets specific criteria. However, it&#8217;s beneficial when you want to filter your spreadsheet data based on multiple conditions &amp; then detect the maximum value within that filtered subset. Now the question arises, <strong>how to use MAXIFS in Excel<\/strong> \u2026?<!--more--><\/p>\n<p>In this helpful guide, you will learn each and everything that you need to know about the <strong>MAXIFS function. <\/strong>So, let\u2019s get started\u2026<\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To fix corrupted Excel files, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h2 style=\"text-align: left;\"><strong>What Is Maxifs Formula? <\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>Excel MAXIFS functions<\/strong> basically return the biggest numeric value that matches one or more criteria in the range of values.<\/p>\n<p style=\"text-align: justify;\">MAXIFS is used with criteria based on the text, numbers, dates, and other conditions.<\/p>\n<p style=\"text-align: justify;\"><strong>Objective to use:\u00a0<\/strong><\/p>\n<p style=\"text-align: justify;\">To get the maximum value using the criteria<\/p>\n<p style=\"text-align: justify;\"><strong>Return value\u00a0<\/strong><\/p>\n<p style=\"text-align: justify;\">Maximum value<\/p>\n<p style=\"text-align: justify;\"><strong>Syntax\u00a0<\/strong><\/p>\n<p style=\"text-align: justify;\">=MAXIFS (max_range, range1, criteria1, [range2], [criteria2], &#8230;)<\/p>\n<p style=\"text-align: justify;\"><strong>Arguments\u00a0<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li><em>max_range<\/em>&#8211; Range of values is used for determining the maximum result.<\/li>\n<li><em>range1<\/em>\u2013 1<sup>st<\/sup> range to evaluate.<\/li>\n<li><em>criteria1<\/em>&#8211; criteria for using the range1.<\/li>\n<li><em>Range2<\/em>&#8211; [optional] 2nd range to evaluate.<\/li>\n<li><em>Criteria2<\/em>&#8211; [optional] criteria for using the range2.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Version\u00a0<\/strong><\/p>\n<p style=\"text-align: justify;\">Excel 2019, Excel 365<\/p>\n<h2 style=\"text-align: left;\"><strong>How to Use MAXIFS In Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Maxif function returns the largest numeric value that matches one or more assigned criteria.<\/p>\n<p style=\"text-align: justify;\">To apply criteria over dates, text and numbers you can apply MAXIFS functions.<\/p>\n<p style=\"text-align: justify;\">This function supports <strong>wildcards (*,?) and logical operators (&gt;,&lt;,&lt;&gt;,=)<\/strong> for the partial matching.<\/p>\n<p style=\"text-align: justify;\">It mainly takes 3 required\u00a0arguments:<\/p>\n<p style=\"text-align: justify;\"><strong><em>max_range<\/em>,\u00a0<em>range1<\/em>, and\u00a0<em>criteria1<\/em>.<\/strong><\/p>\n<p style=\"text-align: justify;\">Using these 3 arguments, this MAXIFS function gives the largest number in the<em> max_range<\/em>\u00a0where <em>range1<\/em> corresponding cells\u00a0match with the\u00a0condition assigned by the\u00a0<em>criteria1<\/em>.<\/p>\n<p style=\"text-align: justify;\">If you want to add some more conditions then apply it using the criteria\/range pairs.<\/p>\n<p style=\"text-align: justify;\">2<sup>nd<\/sup> condition is defined by <em>criteria2 and range2 and so on. Maximum this function allows <\/em>126 pairs of range\/criteria.<\/p>\n<p style=\"text-align: justify;\">MAXIFS is basically a group of 8 functions which divide the logical criteria into two main parts i.e, criteria + range.<\/p>\n<p style=\"text-align: justify;\">Due to this, the syntax which is used for making criteria is quite different. MAXIFS <em>needsa\u00a0 <\/em>cell range for the range arguments. So you are not allowed to use an array.<\/p>\n<p style=\"text-align: justify;\">MAXIFS is a newly added function in the Excel application; thus, it is available only in <strong>Excel 2019 and <\/strong><strong>365<\/strong><strong> versions<\/strong>. Whereas, in the previous Excel version you have to use array formula, which is mainly based on the IF and MAX to extract maximum values using the criteria.<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Examples To Show How To Use Maxifs In Excel<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Let\u2019s know how to use maxifs in Excel more clearly with some examples. I have explained <strong>how to use Excel maxifs function<\/strong> in one criterion and two criterions.<\/p>\n<h4 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>MAXIFS &#8211; One Criterion<\/strong><\/span><\/h4>\n<p style=\"text-align: justify;\"><strong>Excel 365:<\/strong><\/p>\n<p style=\"text-align: justify;\">Following formula will fetch the maximum quantity of the product name which is present in cell B6.<\/p>\n<p style=\"text-align: justify;\"><strong>=MAXIFS(tblProdCust[Qty], tblProdCust[Product], B4#)<\/strong><\/p>\n<p style=\"text-align: justify;\">To make product\u2019s unique list spill formula is applied on the cell B6. MAXIFS formula is included with spill operator (#) which is at the end of that particular cell reference B4#. This will spill down the MAXIFS result.<\/p>\n<p style=\"text-align: justify;\"><strong>Excel 2019: <\/strong><\/p>\n<p style=\"text-align: justify;\">You won\u2019t get this Spill formula in Excel 2019 version. So in this Excel version, you need to refer this cell B4, but without spill operator after that copy the manually.<\/p>\n<p style=\"text-align: justify;\"><strong>=MAXIFS(tblProdCust[Qty], tblProdCust[Product], B4)<\/strong><\/p>\n<p style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>MAXIFS &#8211; Two criterion<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">In the shown example, the formulas in G5 and G6 are:<\/p>\n<p style=\"text-align: justify;\"><strong>=MAXIFS(D5:D16,C5:C16,&#8221;F&#8221;) \/\/ returns 93<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>=MAXIFS(D5:D16,C5:C16,&#8221;M&#8221;) \/\/ returns 83<\/strong><\/p>\n<p style=\"text-align: justify;\">In <strong>1<sup>st<\/sup> <\/strong>formula,<strong> MAXIFS<\/strong> gives the maximum value within <strong>D5:D16,<\/strong> whereas <strong>C5:C16<\/strong> is equal to <strong>&#8220;F&#8221; (93).<\/strong><\/p>\n<p style=\"text-align: justify;\">In <strong>2<sup>nd<\/sup> <\/strong>formula, <strong>MAXIFS<\/strong> returns the maximum value in <strong>D5:D1,6,<\/strong> whereas <strong>C5:C16<\/strong> is equal to <strong>&#8220;M&#8221; (83).<\/strong><\/p>\n<p style=\"text-align: justify;\">In the given example, the MAXIFS function is used with 2 criteria. One e for the <strong>group <\/strong>and another is for the Gender.<\/p>\n<p style=\"text-align: justify;\">Conditions are included in the range\/criteria pairs, whereas <strong>E5:E16<\/strong> is paired along with the <strong>&#8220;B&#8221;<\/strong> condition.<\/p>\n<p style=\"text-align: justify;\">Formulas in H5:I6 are:<\/p>\n<p style=\"text-align: justify;\"><strong>H5=MAXIFS(D5:D16,C5:C16,&#8221;F&#8221;,E5:E16,&#8221;A&#8221;) \/\/ returns 93<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>I5=MAXIFS(D5:D16,C5:C16,&#8221;F&#8221;,E5:E16,&#8221;B&#8221;) \/\/ returns 85<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>H6=MAXIFS(D5:D16,C5:C16,&#8221;M&#8221;,E5:E16,&#8221;A&#8221;) \/\/ returns 83<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>I6=MAXIFS(D5:D16,C5:C16,&#8221;M&#8221;,E5:E16,&#8221;B&#8221;) \/\/ returns 79<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>Other criteria<\/strong><\/p>\n<p style=\"text-align: justify;\">To get the maximum value in the A1:A100 when the cells in B1:B100 are more than 50.<\/p>\n<p style=\"text-align: justify;\"><strong>=MAXIFS(A1:A100,B1:B100,&#8221;&gt;50&#8243;)<\/strong><\/p>\n<p style=\"text-align: justify;\">In order to maximum value in A1:A100 when cells in B1:B100 are equal to or less than 100. Cells in C1:C100 are more than 0.<\/p>\n<p style=\"text-align: justify;\"><strong>=MAXIFS(A1:A100,B1:B100,&#8221;&lt;=100&#8243;,C1:C100,&#8221;&gt;0&#8243;)<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>Not equal to<\/strong><\/p>\n<p style=\"text-align: justify;\">To apply the criteria of &#8220;not equal to&#8221; you need to use <strong>&#8220;&lt;&gt;&#8221;\u00a0<\/strong>operator\u00a0enclosed within the double quotes<strong> (&#8220;&#8221;).<\/strong><\/p>\n<p style=\"text-align: justify;\">E.g, to get the maximum value in A1:A100 when the cells in B1:B100 is not equal to \u201cred\u201d.<\/p>\n<p style=\"text-align: justify;\"><strong>=MAXIFS(A1:A100,B1:B100,&#8221;&lt;&gt;red&#8221;)<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>Value From Another Cell<\/strong><\/p>\n<p style=\"text-align: justify;\">If you are using the value of another cell in your condition, then the cell reference must need to be concatenated with the operator.<\/p>\n<p style=\"text-align: justify;\">e.g: in order to get the maximum value within A1:A100 when the cells present in B1:B100 are more than the value of C1.<\/p>\n<p style=\"text-align: justify;\"><strong>=MAXIFS(A1:A100,B1:B100,&#8221;&gt;&#8221;&amp;C1)<\/strong><\/p>\n<p style=\"text-align: justify;\">You need to only keep the sign of the greater operator (&gt;) enclosed within the quotes (&#8220;&#8221;).<\/p>\n<p style=\"text-align: justify;\"><strong>Wildcards<\/strong><\/p>\n<p style=\"text-align: justify;\">In the MAXIFS criteria you can make use the wildcard\u00a0characters like, <strong>asterisk (*), question marks (?) or tilde (~).<\/strong><\/p>\n<p style=\"text-align: justify;\">A question mark (?) is used for matching with only one character. Whereas, asterisk (*) matches 0 or more character.<\/p>\n<p style=\"text-align: justify;\">For example,<\/p>\n<p style=\"text-align: justify;\">Return the maximum value in A1:A100 when cells present in the B1:B100 starts with letter\u201da\u201d:<\/p>\n<p style=\"text-align: justify;\"><strong>=MAXIFS(A1:A100,B1:B100,&#8221;a*&#8221;)<\/strong><\/p>\n<p style=\"text-align: justify;\">The tilde (~) is basically an escape character which helps to find literal wildcards.<\/p>\n<p style=\"text-align: justify;\">Suppose you need to match the literal question mark (?), tilde (~), or asterisk(*), then you only need to use a tilde sign at the start of wildcard characters(i.e. ~?, ~*, ~~).<\/p>\n<p style=\"text-align: justify;\"><strong>Notes<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Conditions are mainly applied\u00a0by using the range\/criteria in pairs.<\/li>\n<li>All the ranges and criteria that you assign must have the same size otherwise the MAXIFS function will throw the <strong>#VALUE!<\/strong> error.<\/li>\n<li>If none of the cells match with the criteria, then MAXIFS will give a zero (0) result.<\/li>\n<li>Automatically, MAXIFS ignores all the empty cells present in the <em>max_range <\/em>that match well with the criteria.<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>Related FAQs:<\/strong><\/h2>\n<p style=\"text-align: justify;\">        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Can I Use Instead of Maxifs in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tNo, there is no such MAXIF function in the older version of Excel application. Excel only offers COUNTIF and SUMIF function. In order to make your own MAXIF just use the IF and MAX functions together in the array formula.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Does Maxifs Work in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tThe MAXIFS function in Excel returns the determined value among the cells specified by a given set of the conditions or criteria.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Why is Maxifs Returning 0?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tThe max_range holds only non-numeric values. If the cells range in which you need to locate the maximum value has only non-numeric values, the function will immediately return zero.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Does Excel Have a Maxif Function?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIn Excel latest versions like Excel 365 and Excel 2019, this Maxifs Function is available. In the previous version of Excel, you need to use the array formula mainly based on the IF and MAX to extract maximum values using the criteria.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Is the Formula for Maxifs Array?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tThe syntax you can use for the MAXIFS function is: <strong>MAXIFS(max_range, criteria_range1, criteria1, criteria_range2, criteria2<\/strong>, \u2026)                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Can I Use Instead of Maxifs in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"No, there is no such MAXIF function in the older version of Excel application. Excel only offers COUNTIF and SUMIF function. In order to make your own MAXIF just use the IF and MAX functions together in the array formula.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Does Maxifs Work in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"The MAXIFS function in Excel returns the determined value among the cells specified by a given set of the conditions or criteria.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Why is Maxifs Returning 0?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"The max_range holds only non-numeric values. If the cells range in which you need to locate the maximum value has only non-numeric values, the function will immediately return zero.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Does Excel Have a Maxif Function?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"In Excel latest versions like Excel 365 and Excel 2019, this Maxifs Function is available. In the previous version of Excel, you need to use the array formula mainly based on the IF and MAX to extract maximum values using the criteria.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Is the Formula for Maxifs Array?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"The syntax you can use for the MAXIFS function is: <strong>MAXIFS(max_range, criteria_range1, criteria1, criteria_range2, criteria2<\/strong>, \u2026)\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<h2 style=\"text-align: left;\"><strong>Closure<\/strong><\/h2>\n<p style=\"text-align: justify;\">That\u2019s all; I have given ample information on <strong>how to use maxifs in Excel.<\/strong> So, now it\u2019s your turn to carefully follow the given instruction and get the complete benefit of this function.<\/p>\n<p style=\"text-align: justify;\">I hope you have found this article helpful and informative. Besides this, if you have more knowledge on <strong>Excel Maxifs function <\/strong>then don\u2019t hesitate to share it.<\/p>\n<p style=\"text-align: justify;\">For any further assistance or guidance, you can be in touch with us through our social media <strong><a href=\"https:\/\/www.facebook.com\/MS-Excel-Repair-Tool-1569953153234271\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> &amp; <a href=\"https:\/\/twitter.com\/repairmsexcel\" target=\"_blank\" rel=\"noopener\">Twitter<\/a><\/strong> pages.<\/p>\n<p>Good Luck&#8230;!<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong>External References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/maxifs-function-dfd611e6-da2c-488a-919b-9b6376b28883\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/maxifs-function-dfd611e6-da2c-488a-919b-9b6376b28883<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In Microsoft Excel, MAXIFS is an excellent function that helps to find the largest value in the range that meets &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Uncover the Secrets: How to Use MAXIFS in Excel?\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel#more-6122\" aria-label=\"Read more about Uncover the Secrets: How to Use MAXIFS in Excel?\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":6128,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[632],"tags":[1974,1325],"class_list":["post-6122","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-how-to-apply-maxifs-formula-in-excel","tag-how-to-use-maxifs-in-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Uncover the Secrets: How to Use MAXIFS in Excel?<\/title>\n<meta name=\"description\" content=\"In this blog, we delve into advanced steps on how to use MAXIFS in Excel and streamline your data management tasks.\" \/>\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.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Uncover the Secrets: How to Use MAXIFS in Excel?\" \/>\n<meta property=\"og:description\" content=\"In this blog, we delve into advanced steps on how to use MAXIFS in Excel and streamline your data management tasks.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-05T13:20:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-07T07:15:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/01\/How-To-Use-Maxifs-In-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"963\" \/>\n\t<meta property=\"og:image:height\" content=\"542\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"Uncover the Secrets: How to Use MAXIFS in Excel?\",\"datePublished\":\"2025-08-05T13:20:15+00:00\",\"dateModified\":\"2025-08-07T07:15:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel\"},\"wordCount\":1409,\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/How-To-Use-Maxifs-In-Excel.jpg\",\"keywords\":[\"how to apply MAXIFS formula in Excel\",\"how to use maxifs in Excel\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel\",\"name\":\"Uncover the Secrets: How to Use MAXIFS in Excel?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/How-To-Use-Maxifs-In-Excel.jpg\",\"datePublished\":\"2025-08-05T13:20:15+00:00\",\"dateModified\":\"2025-08-07T07:15:41+00:00\",\"description\":\"In this blog, we delve into advanced steps on how to use MAXIFS in Excel and streamline your data management tasks.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel#primaryimage\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/How-To-Use-Maxifs-In-Excel.jpg\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/How-To-Use-Maxifs-In-Excel.jpg\",\"width\":963,\"height\":542,\"caption\":\"How To Use Maxifs In Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-use-maxifs-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uncover the Secrets: How to Use MAXIFS in Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/priyanka-sahu-2794a1242\"],\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/author\\\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Uncover the Secrets: How to Use MAXIFS in Excel?","description":"In this blog, we delve into advanced steps on how to use MAXIFS in Excel and streamline your data management tasks.","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.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel","og_locale":"en_US","og_type":"article","og_title":"Uncover the Secrets: How to Use MAXIFS in Excel?","og_description":"In this blog, we delve into advanced steps on how to use MAXIFS in Excel and streamline your data management tasks.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2025-08-05T13:20:15+00:00","article_modified_time":"2025-08-07T07:15:41+00:00","og_image":[{"width":963,"height":542,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/01\/How-To-Use-Maxifs-In-Excel.jpg","type":"image\/jpeg"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"Uncover the Secrets: How to Use MAXIFS in Excel?","datePublished":"2025-08-05T13:20:15+00:00","dateModified":"2025-08-07T07:15:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel"},"wordCount":1409,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/01\/How-To-Use-Maxifs-In-Excel.jpg","keywords":["how to apply MAXIFS formula in Excel","how to use maxifs in Excel"],"articleSection":["Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel","name":"Uncover the Secrets: How to Use MAXIFS in Excel?","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/01\/How-To-Use-Maxifs-In-Excel.jpg","datePublished":"2025-08-05T13:20:15+00:00","dateModified":"2025-08-07T07:15:41+00:00","description":"In this blog, we delve into advanced steps on how to use MAXIFS in Excel and streamline your data management tasks.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/01\/How-To-Use-Maxifs-In-Excel.jpg","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/01\/How-To-Use-Maxifs-In-Excel.jpg","width":963,"height":542,"caption":"How To Use Maxifs In Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-use-maxifs-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Uncover the Secrets: How to Use MAXIFS in Excel?"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/6122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=6122"}],"version-history":[{"count":3,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/6122\/revisions"}],"predecessor-version":[{"id":9130,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/6122\/revisions\/9130"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/6128"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=6122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=6122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=6122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}