{"id":30866,"date":"2023-09-08T17:34:53","date_gmt":"2023-09-08T15:34:53","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=30866"},"modified":"2024-02-06T16:07:05","modified_gmt":"2024-02-06T15:07:05","slug":"excel-sumifs-with-date-range","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-sumifs-with-date-range\/","title":{"rendered":"Harnessing the Power of Excel SUMIFS with Date Range &#8211; 2 Useful Examples"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/69CA7DFE-92B7-4A8D-B2DC-584B82D4B44D.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"aligncenter size-large wp-image-30887\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/69CA7DFE-92B7-4A8D-B2DC-584B82D4B44D-1024x576.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/69CA7DFE-92B7-4A8D-B2DC-584B82D4B44D-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/69CA7DFE-92B7-4A8D-B2DC-584B82D4B44D-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/69CA7DFE-92B7-4A8D-B2DC-584B82D4B44D-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/69CA7DFE-92B7-4A8D-B2DC-584B82D4B44D.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>The <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-use-sumifs-function-in-excel\/\" target=\"_blank\"><strong>SUMIFS<\/strong> <\/a>function allows<strong> you to sum values in a range that satisfies multiple conditions.\u00a0<\/strong>When it comes to working with dates, SUMIFS with date range can be particularly handy, especially when you need to sum values within a specific date range.<\/p>\n<p>In this article, we will explore the following topics in detail &#8211;<\/p>\n<div class=\"contents\">\n<h2>Table of Contents<\/h2>\n<ul>\n<li><a href=\"#1\"><strong>Introduction to SUMIFS with date range<\/strong><\/a><\/li>\n<li><a href=\"#2\"><strong>Basic Example<\/strong><\/a><\/li>\n<li><a href=\"#3\"><strong>SUMIFS with dynamic date range<\/strong><\/a><\/li>\n<\/ul>\n<\/div>\n<p>Let us look at each of these topics.<\/p>\n<h4>Download the Excel Workbook below to follow along and understand how to use SUMIFS with date range in Excel \u2013<\/h4>\n<h4><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-date-range.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">SUMIFS-with-date-range.xlsx<\/span><\/a><\/h4>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"1\" style=\"color: #ff0000;\">Introduction to SUMIFS with date range<\/span><\/strong><\/h3>\n<p>SUMIFS allows you to<strong> sum values in a range that meets multiple conditions<\/strong> or criteria. Whether you&#8217;re<strong> analyzing sales data, tracking project milestones, or monitoring expenses<\/strong> over time, SUMIFS can simplify your data calculations.<\/p>\n<p>Its syntax is as follows:<\/p>\n<p><strong>=SUMIFS(Sum_Range,Criteria_Range1,Criteria1,Criteria_Range2,Criteria2\u2026)<\/strong><\/p>\n<ul>\n<li><strong>Sum_Range\u00a0(required)<\/strong> \u2013 The range of cells to sum.<\/li>\n<li><strong>Criteria_Range1\u00a0(required)<\/strong> \u2013 The range that is tested using Criteria1. Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.<\/li>\n<li><strong>Criteria1\u00a0(required)<\/strong> \u2013 The criteria that define which cells in Criteria_range1 will be added. For example, criteria can be entered as 32, \u201c&gt;32\u201d, B4, \u201capples\u201d, or \u201c32\u201d.<\/li>\n<li><em><strong>Criteria_Range2,\u00a0Criteria2, \u2026 (optional)<\/strong> \u2013 Additional ranges and their associated criteria.<\/em><\/li>\n<\/ul>\n<p>For SUMIFS with date range, we need to<strong> provide the start date and the end date as the two criteria<\/strong>. Let us look at a few examples to help us understand this function better.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"2\" style=\"color: #ff0000;\">Basic Example<\/span><\/strong><\/h3>\n<p>Suppose you have <strong>dates in one column and the sales amount in another column<\/strong>, and you want to calculate the <strong>total sales for the month of January<\/strong>. This calculation can easily be done with the help of SUMIFS with date range.<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>Enter the\u00a0<strong>SUMIFS<\/strong> function.<\/p>\n<p><strong>=SUMIFS(<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30868\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-1.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"837\" height=\"557\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-1.png 837w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-1-300x200.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-1-768x511.png 768w\" sizes=\"(max-width: 837px) 100vw, 837px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Enter the first argument \u2013\u00a0<strong>Sum_range<\/strong>. Here we have selected the range B2:B30 as it contains all the sales figures.<\/p>\n<p><strong>=SUMIFS(B2:B30,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30869\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-2.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"855\" height=\"549\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-2.png 855w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-2-300x193.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-2-768x493.png 768w\" sizes=\"(max-width: 855px) 100vw, 855px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>Enter the second argument \u2013<strong>\u00a0Criteria_range1<\/strong>. Here we have selected A2:A30 range as it contains the date of the sales transaction.<\/p>\n<p><strong>=SUMIFS(B2:B30,A2:A30,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30870\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-3.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"875\" height=\"549\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-3.png 875w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-3-300x188.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-3-768x482.png 768w\" sizes=\"(max-width: 875px) 100vw, 875px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong>Enter the third argument \u2013\u00a0<strong>Criteria1.\u00a0<\/strong>Here we have entered the criteria as &#8220;&gt;=&#8221;&amp;1\/1\/2023.<\/p>\n<p><strong>=SUMIFS(B2:B30,A2:A30,&#8221;&gt;=&#8221;&amp;&#8221;1\/1\/2023&#8243;,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30871\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-4.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"933\" height=\"553\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-4.png 933w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-4-300x178.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-4-768x455.png 768w\" sizes=\"(max-width: 933px) 100vw, 933px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5:<\/span> <\/strong>Enter the fourth argument \u2013\u00a0<strong>Criteria_range2.\u00a0<\/strong>Here we have selected A2:A30 range as it contains the date of the sales transaction.<\/p>\n<p><strong>=SUMIFS(B2:B30,A2:A30,&#8221;&gt;=&#8221;&amp;&#8221;1\/1\/2023&#8243;,A2:A30,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30872\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-5.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"1089\" height=\"547\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-5.png 1089w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-5-300x151.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-5-1024x514.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-5-768x386.png 768w\" sizes=\"(max-width: 1089px) 100vw, 1089px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 6:<\/span> <\/strong>Enter the fifth argument \u2013\u00a0<strong>Criteria2.\u00a0<\/strong>Here we have entered \u201c&lt;=&#8221;&amp;1\/31\/2023.<\/p>\n<p><strong>=SUMIFS(B2:B30,A2:A30,&#8221;&gt;=&#8221;&amp;&#8221;1\/1\/2023&#8243;,A2:A30,&#8221;&lt;=&#8221;&amp;&#8221;1\/31\/2023&#8243;)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30873\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-6.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"955\" height=\"555\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-6.png 955w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-6-300x174.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-6-768x446.png 768w\" sizes=\"(max-width: 955px) 100vw, 955px\" \/><\/a><\/p>\n<p>As we can see, the SUMIFS function returns the sum of sales for the month of January, applying multiple criteria at once.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30881\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-14.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"805\" height=\"767\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-14.png 805w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-14-300x286.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-14-768x732.png 768w\" sizes=\"(max-width: 805px) 100vw, 805px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"3\" style=\"color: #ff0000;\">SUMIFS with dynamic date range<\/span><\/strong><\/h3>\n<p>In many cases, you would want to create dynamic date ranges that <strong>automatically adjust based on the current date or other factors<\/strong>. This allows you to analyze data for the current month, quarter, or any other time frame <strong>without manually updating your <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a><\/strong>.<\/p>\n<p>This can be achieved by the help of the formula &#8211; <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/today-formula-in-excel\/\" target=\"_blank\"><strong>TODAY()<\/strong><\/a>. TODAY() function returns the current date and gets updated automatically each day, reflecting the current date.<\/p>\n<p>Suppose you want to calculate the sum of sales for the last 7 days using the SUMIFS function. Follow the steps below to get the result &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>Enter the\u00a0<strong>SUMIFS<\/strong> function.<\/p>\n<p><strong>=SUMIFS(<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30874\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-7.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"787\" height=\"547\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-7.png 787w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-7-300x209.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-7-768x534.png 768w\" sizes=\"(max-width: 787px) 100vw, 787px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Enter the first argument \u2013\u00a0<strong>Sum_range<\/strong>. Here we have selected the range B2:B30 as it contains all the sales figures.<\/p>\n<p><strong>=SUMIFS(B2:B30,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30875\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-8.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"783\" height=\"545\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-8.png 783w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-8-300x209.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-8-768x535.png 768w\" sizes=\"(max-width: 783px) 100vw, 783px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>Enter the second argument \u2013<strong>\u00a0Criteria_range1<\/strong>. Here we have selected A2:A30 range as it contains the date of the sales transaction.<\/p>\n<p><strong>=SUMIFS(B2:B30,A2:A30,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30876\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-9.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"873\" height=\"551\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-9.png 873w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-9-300x189.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-9-768x485.png 768w\" sizes=\"(max-width: 873px) 100vw, 873px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong>Enter the third argument \u2013\u00a0<strong>Criteria1.\u00a0<\/strong>Here we have entered the criteria as greater than 7 days minus today&#8217;s date i.e. &#8220;&gt;&#8221;&amp;TODAY()-7<\/p>\n<p><strong>=SUMIFS(B2:B30,A2:A30,&#8221;&gt;&#8221;&amp;TODAY()-7,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30877\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-10.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"922\" height=\"549\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-10.png 922w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-10-300x179.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-10-768x457.png 768w\" sizes=\"(max-width: 922px) 100vw, 922px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5:<\/span> <\/strong>Enter the fourth argument \u2013\u00a0<strong>Criteria_range2.\u00a0<\/strong>Here we have selected A2:A30 range as it contains the date of the sales transaction.<\/p>\n<p><strong>=SUMIFS(B2:B30,A2:A30,&#8221;&gt;&#8221;&amp;TODAY()-7,A2:A30,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30878\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-11.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"1051\" height=\"549\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-11.png 1051w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-11-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-11-1024x535.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-11-768x401.png 768w\" sizes=\"(max-width: 1051px) 100vw, 1051px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 6:<\/span> <\/strong>Enter the fifth argument \u2013\u00a0<strong>Criteria2.\u00a0<\/strong>Here we have entered the &#8220;&gt;=&#8221;&amp;TODAY() function.<\/p>\n<p><strong>=SUMIFS(B2:B30,A2:A30,&#8221;&gt;&#8221;&amp;TODAY()-7,A2:A30,&#8221;&lt;=&#8221;&amp;TODAY())<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30879\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-12.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"756\" height=\"506\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-12.png 756w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-12-300x201.png 300w\" sizes=\"(max-width: 756px) 100vw, 756px\" \/><\/a><\/p>\n<p>As we can see, the SUMIFS function returns the sum of sales for the last 7 days.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\"  class=\"alignnone size-full wp-image-30880\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-13.png\" alt=\"Harnessing the Power of Excel SUMIFS with Date Range - 2 Useful Examples\" width=\"789\" height=\"773\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-13.png 789w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-13-300x294.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/SUMIFS-with-Date-Range-13-768x752.png 768w\" sizes=\"(max-width: 789px) 100vw, 789px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"3\" style=\"color: #ff0000;\">Conclusion<\/span><\/strong><\/h3>\n<p>Mastering SUMIFS with date range in Excel opens up a world of possibilities for efficient data analysis. Whether you need to <strong>calculate totals for specific months or create dynamic date ranges that adapt to changing time frames<\/strong>, the SUMIFS function is a powerful tool in Excel.<\/p>\n<p><strong>Further learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumifs-function-wildcards\/\" target=\"_blank\" rel=\"noopener\">SUMIFS function: Wildcards *<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumifs-function-introduction\/\" target=\"_blank\" rel=\"noopener\">SUMIFS Function: Introduction<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-use-sumifs-function-in-excel\/\" target=\"_blank\" rel=\"noopener\">How to Use SUMIFS Function in Excel<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Click here<\/strong><\/a> to learn all about SUMIFS in Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SUMIFS function allows you to sum values in a range that satisfies multiple conditions.\u00a0When it comes to working with dates, SUMIFS with date range can be particularly handy, especially when you need to sum values within a specific date range. In this article, we will explore the following topics in detail &#8211; Table of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":30887,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[13,292],"tags":[1361,1360,1358,1359],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/30866"}],"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=30866"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/30866\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/30887"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=30866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=30866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=30866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}