# How to sum with multiple criteria in Excel (SUMIFS)

Use SUMIFS with the sum range first, then one range-and-condition pair per criterion: =SUMIFS(sum_range, range1, crit1, range2, crit2).

**Excel:** `=SUMIFS(D2:D11,B2:B11,G1,C2:C11,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 |  | Region | West |
| 2026-01-05 | West | Laptop | 1840 |  | Product | Monitor |
| 2026-01-11 | East | Monitor | 420 |  | Total |  |
| 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,B2:B11,G1,C2:C11,G2)`

Result: $1,005

## How it works

SUMIFS adds a row only when every condition is true: here the region must equal `G1` **and** the product must equal `G2`. Unlike SUMIF, the range to add comes first, followed by as many range-and-condition pairs as you need.

## Other ways

- `=SUMPRODUCT((B2:B11=G1)*(C2:C11=G2)*D2:D11)`: Multiplying the tests is the same AND logic and works in every version.

## Common mistakes

- Every range must be the same size as the sum range, or SUMIFS returns #VALUE!.
- SUMIFS joins conditions with AND. For OR (Monitor or Dock), add two SUMIFS together.
- Put conditions in cells, as here, rather than typing them into the formula. Then one formula answers every question.

## Questions

**How do I use OR in SUMIFS?**

Add one SUMIFS per option: `=SUMIFS(D2:D11,C2:C11,"Monitor")+SUMIFS(D2:D11,C2:C11,"Dock")`.

**Can I use dates as SUMIFS criteria?**

Yes, with an operator joined to a date cell, like `">="&G4`. See summing between two dates.

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-with-multiple-criteria