{"id":223,"date":"2014-09-23T19:27:26","date_gmt":"2014-09-23T17:27:26","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=223"},"modified":"2024-05-28T17:43:52","modified_gmt":"2024-05-28T15:43:52","slug":"advanced-sumproduct-function-maximum-sales","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-maximum-sales\/","title":{"rendered":"Advanced SUMPRODUCT Function: Maximum Sales"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent 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\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-maximum-sales\/#Advanced_SUMPRODUCT_Function_Maximum_Sales\" title=\"Advanced SUMPRODUCT Function: Maximum Sales\">Advanced SUMPRODUCT Function: Maximum Sales<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Advanced_SUMPRODUCT_Function_Maximum_Sales\"><\/span>Advanced SUMPRODUCT Function: Maximum Sales<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>What makes the\u00a0SUMPRODUCT function even more powerful is its ability to nest <a class=\"wpil_keyword_link\" title=\"formulas\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">formulas<\/a>, or in simple terms, add another function within the SUMPRODUCT function.<\/p>\n<p>Instead of getting the Total Sales for a region, we can extract the Maximum sales value simply by entering the MAX function before the criteria.\u00a0 See how below.<\/p>\n<p><span style=\"color: #0000ff;\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Advanced-Sumproduct_Maximum-Sales.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff;\">download workbook<\/span><\/span><span class=\"postTitle px-3\">Advanced-Sumproduct_Maximum-Sales.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Advanced SUMPRODUCT Function: Maximum Sales What makes the\u00a0SUMPRODUCT function even more powerful is its ability to nest formulas, or in simple terms, add another function within the SUMPRODUCT function. Instead of getting the Total Sales for a region, we can extract the Maximum sales value simply by entering the MAX function before the criteria.\u00a0 See [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17383,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Advanced SUMPRODUCT Function: Maximum Sales","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,15,285],"tags":[43,46],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/223"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=223"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/223\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17383"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}