{"id":59,"date":"2012-01-24T22:54:34","date_gmt":"2012-01-25T04:54:34","guid":{"rendered":"http:\/\/xlfxs.com\/?p=59"},"modified":"2012-01-24T22:54:34","modified_gmt":"2012-01-25T04:54:34","slug":"sum-of-divide-array-formula","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=59","title":{"rendered":"Sum of divide &#8211; Array formula"},"content":{"rendered":"<p>This is the answer to an old question:<\/p>\n<p>Here is the story behind it:<\/p>\n<blockquote><p>I had a client who calls me every now and then asking the same question:<\/p>\n<p>&#8221; Can you please remind me of how I would use an array formula? you know, enter multiple conditions into one <strong><em>SUM<\/em><\/strong> function? &#8221;<\/p>\n<p>Then I go a head and show him the procedure and the result, most of the time he uses phone, so I have to take him with the steps needed.<\/p><\/blockquote>\n<p>Now after these years, I found the xls file in my library, thought it is going to be good to share it here.<\/p>\n<p>It is the one that divide then Sum the totals into one cell (which uses array formula to do that)<\/p>\n<p>Formulas used here are:<\/p>\n<pre>=SUM(C7:C18\/D7:D18)<\/pre>\n<p>In cell G7 (Remember to press CTRL+SHIFT+Enter after pasting to apply the Array formula)<\/p>\n<p>Above formula is equivalent to two formulas, one in column J:<\/p>\n<pre>=C7\/D7<\/pre>\n<p>And another one in cell K7<\/p>\n<pre>=SUM(J:J)<\/pre>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2012\/01\/SUMDIVIDE.zip\"><img decoding=\"async\" class=\"aligncenter\" src=\"\/wp-content\/uploads\/2014\/12\/Download1.png\" alt=\"\"><\/a><\/p>\n\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the answer to an old question: Here is the story behind it: I had a client who calls me every now and then asking the same question: &#8221; Can you please remind me of how I would use an array formula? you know, enter multiple conditions into one SUM function? &#8221; Then I&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=59\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Sum of divide &#8211; Array formula&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":61,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,15,6,56],"tags":[],"class_list":["post-59","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-array-formula","category-basic-math","category-standard_functions","category-sum"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=59"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/59\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/61"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}