{"id":94,"date":"2024-04-26T16:09:28","date_gmt":"2024-04-26T16:09:28","guid":{"rendered":"https:\/\/myallcodes.in\/?p=94"},"modified":"2024-04-26T16:09:29","modified_gmt":"2024-04-26T16:09:29","slug":"excel-formula-to-sum-values-in-a-range-that-meet-specific-criteria","status":"publish","type":"post","link":"https:\/\/myallcodes.in\/index.php\/2024\/04\/26\/excel-formula-to-sum-values-in-a-range-that-meet-specific-criteria\/","title":{"rendered":"Excel formula to sum values in a range that meet specific criteria"},"content":{"rendered":"\n<p>In that case we can use the formula &#8220;<strong>Sumif<\/strong>&#8221; Let&#8217;s take an example to understand it, If I am having salesman names in column &#8220;A&#8221; and sales value of that salesman in column &#8220;B&#8221;  then i can use this formula to get the total sales of each salesman. <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>=SUMIF(A:A,&#8221;Salesman Name&#8221;,B:B)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"415\" height=\"370\" src=\"https:\/\/myallcodes.in\/wp-content\/uploads\/2024\/04\/sumif-1.jpg\" alt=\"\" class=\"wp-image-96\" srcset=\"https:\/\/myallcodes.in\/wp-content\/uploads\/2024\/04\/sumif-1.jpg 415w, https:\/\/myallcodes.in\/wp-content\/uploads\/2024\/04\/sumif-1-300x267.jpg 300w\" sizes=\"auto, (max-width: 415px) 100vw, 415px\" \/><\/figure>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>In that case we can use the formula &#8220;Sumif&#8221; Let&#8217;s take an example to understand it, If I am having salesman names in column &#8220;A&#8221; and sales value of that salesman in column &#8220;B&#8221; then i can use this formula to get the total sales of each salesman.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-94","post","type-post","status-publish","format-standard","hentry","category-power-shell-scripts"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/posts\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/comments?post=94"}],"version-history":[{"count":1,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/posts\/94\/revisions"}],"predecessor-version":[{"id":97,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/posts\/94\/revisions\/97"}],"wp:attachment":[{"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/media?parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/categories?post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myallcodes.in\/index.php\/wp-json\/wp\/v2\/tags?post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}