The formula
Excel & Google SheetsExcelGoogle Sheets
=SUMIFS(C2:C9,A2:A9,">="&B11,A2:A9,"<="&B12)In E2 → 850
Date range + regionExcelGoogle Sheets
=SUMIFS(C2:C9,A2:A9,">="&B11,A2:A9,"<="&B12,B2:B9,"East")In E3 → 200
✓ Tested. All 2 Excel results in this example were recalculated in LibreOffice Calc 25.2 and matched the values shown.
Worked example
Paste the data below into a blank sheet starting at cell A1 (or download the cheat sheet, where every example is set up). Highlighted cells hold the formulas and show the expected results.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Date | Region | Amount | ||
| 2 | Feb 27, 2026 | East | 300 | 850 | |
| 3 | Mar 1, 2026 | West | 450 | 200 | |
| 4 | Mar 9, 2026 | East | 120 | ||
| 5 | Mar 15, 2026 | East | 80 | ||
| 6 | Mar 31, 2026 | West | 200 | ||
| 7 | Apr 1, 2026 | East | 500 | ||
| 8 | Apr 18, 2026 | West | 90 | ||
| 9 | May 2, 2026 | East | 60 | ||
| 10 | |||||
| 11 | From | Mar 1, 2026 | |||
| 12 | To | Mar 31, 2026 |
How it works
- C2:C9
- Values to add.
- A2:A9,">="&B11
- Dates on or after the start date.
- A2:A9,"<="&B12
- Dates on or before the end date.
- B2:B9,"East"
- Any extra criteria pairs.
Common errors and fixes
Result is 0?
The operator is inside the cell reference: use ">="&B11, not ">=B11".
Last day missing?
Dates carry times (e.g. 3/31 14:00). Use "<"&B12+1 instead of "<="&B12.
Why does the formula return #VALUE!?
Ranges are different sizes.
Does this work in Google Sheets?
Yes. The formulas on this page work the same way in Google Sheets.