How to Use SUMIFS with a Date Range in Google Sheets

To use SUMIFS with a date range in Google Sheets, follow these instructions:

1. Organize your data with the date column, criteria columns, and the column containing the values to sum.
2. Identify the date range you want to use for the sum.
3. Use the SUMIFS function with the proper syntax. The syntax for the SUMIFS function is:

SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

where:

• sum_range: The range of cells containing the values you want to sum.
• criteria_range1: The range of cells containing the criteria for the first condition.
• criterion1: The first condition for the sum.
• [criteria_range2, criterion2, ...]: Optional additional criteria for the sum.

4. For the date range criterion, use the comparison operators (">", "<") along with the desired dates.
5. Ensure that the date values in the date range criterion are recognized by Google Sheets as valid dates.

Example

Let's say we have the following data in Google Sheets:

We want to sum the "Amount" values for the "A" category that fall between January 1st, 2021, and February 28th, 2021.

1. Identify the date range: January 1st, 2021, to February 28th, 2021.
2. Use the SUMIFS function with the proper syntax:

=SUMIFS(C2:C7, A2:A7, ">=01/01/2021", A2:A7, "<=02/28/2021", B2:B7, "A")

where:

• C2:C7: The range of cells containing the values to sum (Amount).
• A2:A7: The range of cells containing the dates.
• ">=01/01/2021": The condition for the start of the date range.
• "<=02/28/2021": The condition for the end of the date range.
• B2:B7: The range of cells containing the categories.
• "A": The condition for the "A" category.

3. Press Enter to get the result. In this example, the result is 300, which is the sum of the "Amount" values for the "A" category between January 1st, 2021, and February 28th, 2021.