# How to sum values between two dates in Excel

Use SUMIFS with two date conditions on the same column: =SUMIFS(sum_range, dates, ">="&start, dates, "<="&end).

**Excel:** `=SUMIFS(D2:D11,A2:A11,">="&G1,A2:A11,"<="&G2)` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E | F | G |
| --- | --- | --- | --- | --- | --- | --- |
| Date | Region | Product | Sales |  | From | 2026-02-01 |
| 2026-01-05 | West | Laptop | 1840 |  | To | 2026-02-28 |
| 2026-01-11 | East | Monitor | 420 |  | Sales |  |
| 2026-01-19 | West | Monitor | 395 |  |  |  |
| 2026-02-02 | North | Laptop | 1720 |  |  |  |
| 2026-02-09 | West | Dock | 210 |  |  |  |
| 2026-02-16 | East | Laptop | 1955 |  |  |  |
| 2026-02-23 | West | Monitor | 610 |  |  |  |
| 2026-03-03 | South | Monitor | 380 |  |  |  |
| 2026-03-10 | West | Laptop | 2100 |  |  |  |
| 2026-03-17 | East | Dock | 185 |  |  |  |

Formula in G3: `=SUMIFS(D2:D11,A2:A11,">="&G1,A2:A11,"<="&G2)`

Result: $4,495

## How it works

Two conditions on the date column make a window: on or after `G1` and on or before `G2`. The operators are text, so they go in quotes and `&` joins each one to its date cell.

## Other ways

- `=SUMPRODUCT((A2:A11>=G1)*(A2:A11<=G2)*D2:D11)`: Works in every version and takes any extra condition you can write as a test.

## Common mistakes

- Dates typed into the criteria as text, like `">=2/1/2026"`, depend on regional date settings. Keep dates in cells.
- If the dates include times, use `"<"&G2+1` for the end so the whole last day is included.

## Questions

**How do I sum by month?**

Put the first day of the month in G1 and use `"<="&EOMONTH(G1,0)` as the end condition.

**How do I add a region condition too?**

Add a pair: `=SUMIFS(D2:D11,A2:A11,">="&G1,A2:A11,"<="&G2,B2:B11,"West")`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-29.

Source: https://spreadsheetpractice.com/formulas/sum-between-two-dates