# How to SUMIF Between Two Dates in Google Sheets (3 Ways)

Efficiently tracking business performance is crucial, and one way to do this is by using the SUMIF function in Google Sheets to quickly and easily sum data between two specific dates. With the SUMIF function in Google Sheets, you can easily analyze your sales, expenses, or any other data that is between two dates or has a date associated with it.

## 3 Suitable Ways to SUMIF Between Two Dates in Google Sheets

One of the most useful features in Google Sheets is the SUMIF function, which allows you to sum cell values based on a given set of conditions. When it comes to working with dates, the SUMIF function can be especially helpful. There are three main ways to use SUMIF to sum cell values between two dates in Google Sheets.

Assuming that we have a dataset that includes a column for the date and another column for the quantity sold, we will use this dataset to illustrate the different methods for using SUMIF to sum values between two dates in Google Sheets.

### 1. Using SUMIF Function

We have a dataset with sales information, including the date and the quantity sold. To find out how many units were sold between January 3rd, 2022, and January 6th, 2022, we will use the SUMIF function in Google Sheets. The start date is January 3rd, and the end date is January 6th. Follow these steps to understand how the formula works.

Steps:

• First, we are going to select cell E11.
• We will use the following formula first to sum the values in column C (C5:C12) where the corresponding date in column B (B5:B12) is greater than or equal to “03/1/2022“.
`=SUMIF(B5:B12,">=03/1/2022",C5:C12)`

• The next step is to use the SUMIF function again on column C (C5:C12) to find the sum of values where the corresponding date in column B (B5:B12) is greater than “06/1/2022”.
• Then, the second SUMIF function is subtracted from the result of the first SUMIF function to get:
`=SUMIF(B5:B12,">=03/1/2022",C5:C12)-SUMIF(B5:B12,">06/1/2022",C5:C12)`

• Finally, press ENTER to see the result.

The final result of using the SUMIF formula with the specified dates of 3rd and 6th January 2022 is 285. This result represents the total quantity sold within that time period.

### 2. Utilizing the DATE Function with SUMIF

We can also solve the problem using the DATE function with the SUMIF function. Check the following steps to understand.

Steps:

• Firstly, we are going to select cell, E11 once again.
• Secondly, we will use the same formula as before. However, instead of using the date as a cell reference, we will use the DATE function to make the calculation more accurate and precise.
`=SUMIF(B5:B12,">="&DATE(2022,1,3),C5:C12)-SUMIF(B5:B12,">"&DATE(2022,1,6),C5:C12)`
• To see the outcome, press ENTER.

Using the DATE function in the SUMIF formula allows for a more accurate calculation of the sum between specific dates. Resulting in the same outcome.

### 3. Applying SUMIFS Function

We can make the formula and calculation easy by using the SUMIFS function. This is our recommended method to sum values if they are between two dates in Google Sheets. Check the following steps to understand the use of SUMIFS between two dates.

Steps:

• Once again, we will select cell E11.
• Then, we use the SUMIFS function, which allows us to specify multiple criteria to sum the range of cells (C5:C12).
• We set the first criteria to be column B (B5:B12) being greater than or equal to “03/01/2022
• The second criteria is the same column B being less than or equal to “06/01/2022
• Finally, press ENTER to see the result of summing the values in column C that meet both of these criteria in column B.
`=SUMIFS(C5:C12,B5:B12,">=03/01/2022",B5:B12,"<=06/01/2022")`

The SUMIFS formula allows for an easy and efficient way to sum cell values between two given dates in Google Sheets. In this case, the result was 285, showing the smoothness of the function in achieving the desired outcome.

#### DATE Function with SUMIFS

We can also incorporate the DATE function with SUMIFS to calculate the sum between two numbers or dates. Check the following example.

Steps:

• Firstly, we select cell E11.
• Then we use the SUMIFS function to sum the values in column C (C5:C12) where the corresponding date in column B (B5:B12) is greater than or equal to “03/01/2022” and less than or equal to “06/01/2022“.
• The DATE function is used inside the SUMIFS function to ensure a more accurate and precise calculation.
`=SUMIFS(C5:C12,B5:B12,">="&DATE(2022,1,3),B5:B12,"<="&DATE(2022,1,6))`

The result is 285, as the sum of sales between 3rd January and 6th January 2022.

## Conclusion

The use of the SUMIFS function to sum values between two given dates in Google Sheets is a crucial tool for businesses to analyze and track their sales performance over time. It allows for a more accurate and efficient way to gather data, making it a valuable asset for decision-making. Check our website, OfficeWheel, for more help in the decision-making process.

## Related Articles

#### Ishrak Khan

Ishrak Khan is a writer and urban planner born in Dhaka, Bangladesh, one of the largest mega-cities. He is a professional Content Developer closely working with OfficeWheel. He simply likes to enthrall his readers. He loves Football, Nico Robin, Deserts, and Twix. If you like the post, give him a heart on Instagram.

We will be happy to hear your thoughts