Google Sheets functions / Math
Math function · Google Sheets
SUMIFS function
SUMIFS adds the numbers in one range when other ranges meet every condition you set. It is the standard function for totals by region, month, person or status.
Syntax
=SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])Arguments
| Argument | Required | Meaning |
|---|---|---|
| sum_range | Yes | The numbers to add. |
| criteria_range1 | Yes | The first range to test. |
| criteria1 | Yes | The condition, such as "East" or ">=1000". |
| more pairs | No | Add a range and condition for each extra test. |
Worked example
| A | B | C | |
|---|---|---|---|
| 1 | Region | Month | Sales |
| 2 | East | Jan | 1200 |
| 3 | West | Jan | 950 |
| 4 | East | Feb | 1400 |
| 5 | West | Feb | 800 |
| 6 | East | Feb | 300 |
=SUMIFS(C2:C6,A2:A6,"East",B2:B6,"Feb")Result: 1700
Only rows where Region is East and Month is Feb count: 1,400 plus 300.
Try it
Edit the formula and run it against the table above. Results come from a browser spreadsheet engine.
Availability
| Platform | Status |
|---|---|
| Excel | All current desktop versions, Microsoft 365, Excel for the web. |
| Google Sheets | Available. |
Common mistakes
- All ranges must have the same size.
- Comparison operators go inside quotes and join a cell with &, as in ">="&F1.
- SUMIF takes its arguments in a different order, so the two are easy to mix up.
Do it with AI
Paste this prompt into Copilot, Gemini or another assistant. Check the result on a small sample first.
Sales are in column C, regions in A and dates in B. Write a SUMIFS for region F1 between the dates in F2 and F3.