If you are looking for some of the easiest ways to **SUMIF **between two dates and another criteria, then you will find this article useful. Adding up values within a limit of time periods and based on criteria is needed to be done sometimes and to do this task quickly you can follow this article.

**Table of Contents**hide

## How to SUMIF between Two Dates and with Another Criteria: 7 Easy Ways

Here, we have the following dataset containing sales records of some products with their estimated delivery dates and selling regions of a company. Using this dataset we will demonstrate the ways of summing up sales values based on a specified region and date range.

We have used *Microsoft Excel 365* version here, you can use any other versions according to your convenience.

__Method-1__: Using SUMIFS Function to SUMIF between Two Dates with Another Criteria

We want to sum up the sales values for the **East Region **and for the dates between ** 1/10/2022 **and

**(m-dd-yyyy) by using the**

*3/20/2022***SUMIFS function**here.

** Steps**:

➤ Type the following formula in cell

**E14**.

`=SUMIFS(E4:E11,C4:C11,">="&B14,C4:C11,"<="&C14,D4:D11,"East")`

Here, **E4:E11 **is the sales range which values we want to sum, **C4:C11 **is the date range for the first criteria, **“>=”&B14 **is the first criteria which means **greater than or equal to** the start date ** 1/10/2022**. The second criteria range is similar to the first one and the criteria for this range is

**“<=”&C14**which means

**less than or equal to**the end date

**and the last criteria range is**

*3/20/2022***D4:D11**containing the regions, the criteria for this range would be

**.**

*East*➤ Press **ENTER**.

Now, you will get the sum of sales of ** $13,806.00** for our defined date range with another criterion:

**.**

*East*Region__Method-2__: Using SUMIFS and EOMONTH to SUMIF between Two Dates with Another Criteria

In this section, we will try to find the sum of the sales values for the dates of ** January **month and the

**. So, we will use the**

*South*Region**EOMONTH function**with the

**SUMIFS function**here.

** Steps**:

➤ Type the following formula in cell

**D14**.

`=SUMIFS(E4:E11,C4:C11,">="&B14,C4:C11,"<="&EOMONTH(B14,0),D4:D11,C14)`

Here, **E4:E11 **is the sales range which values we want to sum, **C4:C11 **is the date range for the first criteria, **“>=”&B14 **is the first criteria which means **greater than or equal to** the start date ** 1/1/2022**. The second criteria range is similar to the first one and the criteria for this range is

**“<=”&EOMONTH(B14,0)**which means

**less than or equal to**the end date of

**month,**

*January*

*1/31/2022**,*and the last criteria range is

**D4:D11**containing the regions, the criteria for this range would be

**.**

*East*➤ Press **ENTER**.

After that, you will get the sum of sales, ** $6,835.00** for the dates of

**month with another criterion:**

*January***.**

*South*Region__Method-3__: SUMIFS and DATE Functions to SUMIF between Two Dates

Here, we will be using the **SUMIFS function **and the **DATE function**, to sum up, the sales values for the **North Region **and for the dates within

**and**

*1/10/2022***.**

*3/20/2022*** Steps**:

➤ Type the following formula in cell

**E14**.

`=SUMIFS(E4:E11,C4:C11,">="&DATE(2022,1,10),C4:C11,"<="&DATE(2022,3,20),D4:D11,D14)`

Here, **E4:E11 **is the sales range which values we want to sum, **C4:C11 **is the date range for the first and second criteria, and the last criteria range is **D4:D11 **containing the regions.

returns a number of a date value`DATE(2022,1,10)`

→**Output →**44571

becomes`">="&DATE(2022,1,10)`

`">= 44571"`

returns a number of a date value`DATE(2022,3,20)`

→**Output →**44640

becomes`"<="&DATE(2022,3,20)`

`"<= 44640"`

becomes`SUMIFS(E4:E11,C4:C11,">="&DATE(2022,1,10),C4:C11,"<="&DATE(2022,3,20),D4:D11,D14)`

checks if the date values of the range`SUMIFS(E4:E11,C4:C11,">= 44571",C4:C11,"<= 44640",D4:D11, “North”)`

→**C4:C11**are greater than or equal to**44571**and less than or equal to**44640**and the region**North**in the**D4:D11**range**Output →**$9,496.00

➤ Press **ENTER**.

Then, you will get the sum of sales, ** $9,496.00** for our defined date range with the other criteria:

**North Region**.

__Method-4__: Using SUMIFS Function with TODAY

Suppose, you want to get the total sales values for the dates between ** 1/1/2022 **and today’s date (

**3/23/2022**) and for the

**East Region**. And, to do this you can use the

**TODAY function**along with the

**SUMIFS function**.

** Steps**:

➤ Type the following formula in cell

**D14**.

`=SUMIFS(E4:E11,C4:C11,">="&B14,C4:C11,"<="&TODAY(),D4:D11,C14)`

Here, **E4:E11 **is the sales range which values we want to sum, **C4:C11 **is the date range for the first and second criteria, and the last criteria range is **D4:D11 **containing the regions.

becomes`">="&B14`

`">= 44562"`

returns today’s date`TODAY()`

→**Output →**44643 (3/23/2022)

becomes`"<="&TODAY()`

`"<= 44643"`

becomes`SUMIFS(E4:E11,C4:C11,">="&DATE(2022,1,10),C4:C11,"<="&DATE(2022,3,20),D4:D11,D14)`

checks if the date values of the range`SUMIFS(E4:E11,C4:C11,">= 44562",C4:C11,"<= 44643",D4:D11, “East”)`

→**C4:C11**are greater than or equal to**44562**and less than or equal to**44643**and the region**East**in the**D4:D11**range**Output →**$15,208.00

➤ Press **ENTER**.

Finally, you will get the sum of sales which is ** $15,208.00** for the dates between the first day of

**and today’s date with criteria:**

*January 2022***.**

*East*RegionIf you want to change the last date of the date range from today’s date to 10 days prior to today’s date then use the following formula

`=SUMIFS(E4:E11,C4:C11,">="&B14,C4:C11,"<="&TODAY()-10,D4:D11,C14)`

For the last date as a date 10 days following today’s date

`=SUMIFS(E4:E11,C4:C11,">="&B14,C4:C11,"<="&TODAY()+10,D4:D11,C14)`

__Method-5__: Combination of SUM and IF Functions to SUMIF between Two Dates and with Another Criteria

You can use the combination of the **SUM function** and the **IF function** to calculate the total sales for the dates between ** 1/10/2022 **to

**and for the**

*3/20/2022***.**

*East*Region** Steps**:

➤ Type the following formula in cell

**E14**.

`=SUM(IF((C4:C11)>=B14,IF((C4:C11)<=C14,IF(D4:D11=D14,E4:E11))))`

Here, **E4:E11 **is the sales range which values we want to sum, **C4:C11 **is the date range for the first and second criteria, and the last criteria range is **D4:D11 **containing the regions.

checks if the date values of the range`IF((C4:C11)>=B14`

→**C4:C11**are greater than or equal to the value of**B14**.**Output →**`{FALSE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE}`

checks if the date values of the range`IF((C4:C11)<=C14`

→**C4:C11**are less than or equal to the value of**C14**.**Output →**`{TRUE; TRUE; TRUE; TRUE; TRUE; FALSE; TRUE; FALSE}`

checks if the regions of the range`IF(D4:D11=D14,E4:E11)`

→**D4:D11**are equal to the regionof*East***C14**and returns`({TRUE; TRUE; FALSE; TRUE; FALSE; FALSE; FALSE; FALSE}, E4:E11)`

**Output →**`{1402; 5935; FALSE; 7871; FALSE; FALSE; FALSE; FALSE}`

becomes`IF((C4:C11)>=B14,IF((C4:C11)<=C14,IF(D4:D11=D14,E4:E11)))`

→`{FALSE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE}`

`,`

`{TRUE; TRUE; TRUE; TRUE; TRUE; FALSE; TRUE; FALSE}`

`,`

`{1402; 5935; FALSE; 7871; FALSE; FALSE; FALSE; FALSE}`

→`{FALSE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE}, {1402; 5935; FALSE; 7871; FALSE; FALSE; FALSE; FALSE}`

**Output →**`{FALSE; 5935; FALSE; 7871; FALSE; FALSE; FALSE; FALSE}`

becomes`SUM(IF((C4:C11)>=B14,IF((C4:C11)<=C14,IF(D4:D11=D14,E4:E11))))`

`SUM({FALSE; 5935; FALSE; 7871; FALSE; FALSE; FALSE; FALSE})`

**Output →**$13,806.00

➤ Press **ENTER**.

Eventually, you will get the sum of sales, ** $13,806.00** for our defined date range with other criteria:

**East Region**.

__Method-6__: Using SUMPRODUCT, MONTH, and YEAR Functions

Here, we will be using the **SUMPRODUCT function**, the **MONTH function**, and the **YEAR function** to sum up the sales values for the dates of the ** January **month and the

**East**Region.

** Steps**:

➤ Type the following formula in cell

**E14**.

`=SUMPRODUCT((MONTH(C4:C11)=1)*(YEAR(C4:C11)=2022)*(D4:D11=D14)*E4:E11)`

**E4:E11 **is the sales range which values we want to sum, **C4:C11 **is the date range for the first and second criteria, and the last criteria range is **D4:D11 **containing the regions.

returns the month number of the dates`MONTH(C4:C11)`

→ MONTH**Output →**`{1;1;1;2;2;3;3;3}`

becomes`MONTH(C4:C11)=1`

`{1;1;1;2;2;3;3;3}=1`

**Output →**`{TRUE; TRUE; TRUE; FALSE; FALSE; FALSE; FALSE; FALSE}`

returns the year values of the dates`YEAR(C4:C11)`

→**Output →**`{2022;2022;2022;2022;2022;2022;2022;2022}`

becomes`YEAR(C4:C11)=2022`

`{2022;2022;2022;2022;2022;2022;2022;2022}=2022`

**Output →**`{TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE}`

checks if the regions of the range`D4:D11=D14`

→**D4:D11**are equal to the regionof*East***C14****Output →**`{TRUE; TRUE; FALSE; TRUE; FALSE; FALSE; FALSE; FALSE}`

becomes`SUMPRODUCT((MONTH(C4:C11)=1)*(YEAR(C4:C11)=2022)*(D4:D11=D14)*E4:E11)`

→`SUMPRODUCT({TRUE; TRUE; TRUE; FALSE; FALSE; FALSE; FALSE; FALSE}*{TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE}*{TRUE; TRUE; FALSE; TRUE; FALSE; FALSE; FALSE; FALSE}*E4:E11)`

→`SUMPRODUCT({1;1;1;0;0;0;0;0}*{TRUE; TRUE; FALSE; TRUE; FALSE; FALSE; FALSE; FALSE}*E4:E11)`

→`SUMPRODUCT({1;1;0;0;0;0;0;0}*E4:E11) SUMPRODUCT({1402;5935;0;0;0;0;0;0})`

**Output →**$7,337.00

➤ Press **ENTER**.

Afterward, you will get the sum of sales, ** $7,337.00** for

**month with another criterion:**

*January***East Region**.

__Method-7__: VBA Code to SUMIF between Two Dates with Different Criteria

We will use a **VBA **code here to perform the calculation of the total of the sales values between the two dates ** 1/10/2022 **and

**with a criteria**

*3/20/2022***East Region**.

** Steps**:

➤ Go to the

**Developer**Tab >>

**Visual Basic**Option.

Then, the **Visual Basic Editor **will open up.

➤ Go to the **Insert **Tab >> **Module **Option.

After that, a **Module** will be created.

➤ Write the following code

```
Sub sumdatewithcriteria()
Cells(14, 5).Value = Application.WorksheetFunction.SumIfs(Range("E4:E11"), _
Range("C4:C11"), ">=" & DateValue("1/10/2022"), Range("C4:C11"), "<=" & _
DateValue("3/20/2022"), Range("D4:D11"), "East")
End Sub
```

We will get our value in cell **E14 **and **DATEVALUE** will convert the date string into a date value and then after fulfilling the criteria **SUMIFS **will return the added sales value in cell **E14**.

➤ Press **F5**.

Finally, you will get the sum of sales of ** $13,806.00** for our defined date range with another criterion:

**.**

*East*Region**Read More:** How to Use SUMIFS with Date Range and Multiple Criteria

## Practice Section

For doing practice by yourself we have provided a** Practice** section like below in a sheet named **Practice**. Please do it by yourself.

**Download Workbook**

## Conclusion

In this article, we tried to cover the ways to **SUMIF **between two dates and another criteria easily. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.