In this article:

Google Sheets SUMIFS Between Dates (Easiest Way in 2024)

Google Sheets SUMIFS Between Dates

The SUMIFS function in Google Sheets is used to sum cells that meet multiple criteria. When you want to sum values between two dates, you can use SUMIFS by setting the criteria to include a range of dates.

Syntax

Here's the general syntax for using SUMIFS to sum values between two dates:

=SUMIFS(sum_range, date_range, ">=start_date", date_range, "<=end_date")

Where:

sum_range is the range of cells that you want to sum.

date_range is the range of cells that contains the dates.

start_date is the start date of the period for which you want to sum values.

end_date is the end date of the period for which you want to sum values.

Both start_date and end_date should be in a date format that Google Sheets recognizes. They can be hard-coded dates (e.g., "2024-01-01"), references to cells containing dates, or date calculations.

Summing Sales Between Two Specific Dates

To sum sales between two specific dates, we'll be using a dataset with dates in Column A and sales amounts in Column B. Our aim is to calculate the total sales between January 15 and February 5, 2024.

1. Select the Cell for Total Sum

Choose an empty cell where you want the sum to be displayed. For example, click on cell C1. This is where the result of the SUMIFS formula will appear.

google sheets sumifs between dates

2. Type SUMIFS Formula for Sales Between Two Specific Dates

In cell C1, type the formula =SUMIFS(B:B, A:A, ">=2024-01-15", A:A, "<=2024-02-05"). This formula adds up all values in Column B (Sales Amount) where the corresponding date in Column A is between January 15, 2024, and February 5, 2024, inclusive.

sumifs date range google sheets

Summing Customer Numbers from a Specific Date to Today

In this example, we will sum numbers from a specific date to today. This dataset includes the number of customers served each day in Column B and the respective dates in Column A. We will sum the customers served from April 10, 2024 to the current date.

1. Choose the Cell for the Sum Result

Select a blank cell for the sum, such as C1. This cell will display the total customers served.

sumifs between two dates google sheets

2. Insert SUMIFS Formula for Customers Served From a Specific Day to Today

In C1, input =SUMIFS(B:B, A:A, ">=2024-01-10", A:A, "<=" & TODAY()). This formula calculates the total number of customers served from January 10, 2024, up to and including the current date. The TODAY() function automatically updates to the current date each day.

sumifs google sheets date range

Summing Product Sales from a Date to End of That Month

To sum sales from a date to end of that month, we will use a a dataset that contains the number of products sold in Column B and the dates of sale in Column A. The objective is to sum the products sold from January 10 to the end of January 2024.

1. Pick the Cell for Displaying Total Sales

Choose a cell where you want the total sales to be displayed, for instance, C1. This cell will show the sum of products sold in the specified period.

sumifs with date range google sheets

2. Enter SUMIFS Formula for Sales from a Date to End of that Month

Type =SUMIFS(B:B, A:A, ">=2024-05-10", A:A, "<=" & EOMONTH(DATE(2024, 5, 10), 0)) in C1. This formula sums all products sold from January 10, 2024, to January 31, 2024. The EOMONTH function is used to find the last day of January 2024.

Calculating Total Revenue for the Current Month

We're using a dataset with daily revenue figures in Column B and corresponding dates in Column A. The goal is to calculate the total revenue for the current month.

1. Select the Cell for Current Month's Total

Pick a cell, such as C1 to display the sum. This cell will reflect the total revenue for the entire current month.

2. Use SUMIFS Formula for Revenue in the Current Month

In cell C1, type =SUMIFS(B:B, A:A, ">=" & EOMONTH(TODAY(), -1) + 1, A:A, "<=" & EOMONTH(TODAY(), 0)). This formula calculates the total revenue from the first day to the last day of the current month. EOMONTH(TODAY(), -1) + 1 computes the first day of the current month, and EOMONTH(TODAY(), 0) finds the last day of the current month.

We hope that you now have a better understanding of how to use Google Sheets SUMIFS between dates.

Use our rent reminder app to easily set up custom reminders from your spreadsheet in just a few clicks. 

If you enjoyed this article, you might also like our article on how to use SUMIFS formula in Google Sheets or our article on how to use COUNTIF function in Google Sheets.

If you want to learn how to extract a domain from an email in Google Sheets, we also suggest checking out our detailed guide. 

Automate everything you track in spreadsheets with Lido
Learn more

Automate manual tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started