---
title: "SUMIFS function in Excel: syntax and examples | ExcelSavvy"
description: "How to use SUMIFS in Excel and Google Sheets: add up rows that match several conditions. Syntax, examples and a live drill."
canonical_url: "https://excelsavvy.com/functions/sumifs"
meta:
  "og:description": "How to use SUMIFS in Excel and Google Sheets: add up rows that match several conditions. Syntax, examples and a live drill."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNSUZTIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBTVU1JRlMgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IGFkZCB1cCByb3dzIHRoYXQgbWF0Y2ggc2V2ZXJhbCBjb25kaXRpb25zLiBTeW50YXgsIGV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~U1VNSUZTKHN1bV9yYW5nZSwgY3JpdGVyaWFfcmFuZ2UxLCBjcml0ZXJpYTEsIFtjcml0ZXJpYV9yYW5nZTIsIGNyaXRlcmlhMl0sIC4uLik%2Cp_Ii9mdW5jdGlvbnMvc3VtaWZzIg%2Cs_OWFOs75w9f3gFsMh.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "SUMIFS function in Excel: syntax and examples | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNSUZTIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBTVU1JRlMgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IGFkZCB1cCByb3dzIHRoYXQgbWF0Y2ggc2V2ZXJhbCBjb25kaXRpb25zLiBTeW50YXgsIGV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~U1VNSUZTKHN1bV9yYW5nZSwgY3JpdGVyaWFfcmFuZ2UxLCBjcml0ZXJpYTEsIFtjcml0ZXJpYV9yYW5nZTIsIGNyaXRlcmlhMl0sIC4uLik%2Cp_Ii9mdW5jdGlvbnMvc3VtaWZzIg%2Cs_OWFOs75w9f3gFsMh.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **The SUMIFS function**

Adds the cells that meet every one of several conditions. The sum range comes first.

=

SUMIFS(

## **How to use SUMIFS**

SUMIFS adds amounts when several conditions are true at the same time. Think of a sales list where you only want the North region and only shoes: a row counts when it passes every test.

The big difference from SUMIF is the argument order. SUMIFS starts with the range to add, then takes pairs of a range to check and its condition: `**=SUMIFS(C2:C10,A2:A10,"North",B2:B10,"Shoes")**`. Because the sum range comes first, you can add as many pairs as you need, but every range must have the same number of rows.

The conditions are joined with AND. For a period, use the same date column twice, once with `**">="&F1**` and once with `**"<="&F2**`. Operators, wildcards such as `**"*shoe*"**`, and cell references work as in SUMIF.

With a single condition, SUMIF is a little shorter. To count the matching rows instead of adding them, use COUNTIFS, which has no sum range at all. When either of two conditions may be true, add two SUMIFS together.

## **Syntax**

```
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
```

<dl><dt>**sum_range **</dt>
<dd>The cells to add.</dd>
<dt>**criteria_range1 **</dt>
<dd>The cells the first condition is checked against.</dd>
<dt>**criteria1 **</dt>
<dd>The first condition.</dd>
<dt>**criteria_range2, criteria2 **(optional)</dt>
<dd>More range and condition pairs, up to 127.</dd></dl>

## **Examples**

E1`=SUMIFS(<sup>1</sup>C2:C6,<sup>2</sup>A2:A6,<sup>3</sup>"North",<sup>4</sup>B2:B6,<sup>5</sup>"Shoes")`

|  | A | B | C | D | E |
| --- | --- | --- | --- | --- | --- |
| 1 | Region | Product | Sales |  | **920** |
| 2 | North | Shoes | 500 |  | |
| 3 | South | Shoes | 300 |  | |
| 4 | North | Bags | 250 |  | |
| 5 | North | Shoes | 420 |  | |
| 6 | South | Bags | 180 |  | |

**In plain words:** Add up <sup>1</sup>the sales in C2:C6 on the rows where <sup>2</sup>the region in A2:A6 is <sup>3</sup>North and <sup>4</sup>the product in B2:B6 is <sup>5</sup>Shoes.

E1=SUMIFS(C2:C6,A2:A6,"South",C2:C6,">200")

|  | A | B | C | D | E |
| --- | --- | --- | --- | --- | --- |
| 1 | Region | Product | Sales |  | **300** |
| 2 | North | Shoes | 500 |  | |
| 3 | South | Shoes | 300 |  | |
| 4 | North | Bags | 250 |  | |
| 5 | North | Shoes | 420 |  | |
| 6 | South | Bags | 180 |  | |

## **Common SUMIFS mistakes**

- SUMIFS returns #VALUE!

  The ranges are not the same size, as in `**=SUMIFS(C2:C6,A2:A7,"North")**`. Make every range cover the same rows.
- Changing SUMIF to SUMIFS gives 0, an error or the wrong total

  The sum range moved. SUMIF ends with it and SUMIFS starts with it, so `**=SUMIF(A2:A6,"North",C2:C6)**` becomes `**=SUMIFS(C2:C6,A2:A6,"North")**`.
- SUMIFS returns 0 when I ask for two values in the same column

  The conditions are joined with AND, and no cell is both North and South, so `**=SUMIFS(C2:C6,A2:A6,"North",A2:A6,"South")**` gives 0. Add two SUMIFS instead: `**=SUMIFS(C2:C6,A2:A6,"North")+SUMIFS(C2:C6,A2:A6,"South")**`.
- A date condition adds nothing

  A date typed inside quotes depends on the date settings of the file, and dates stored as text never match. Build the date with DATE: `**=SUMIFS(C2:C100,A2:A100,">="&DATE(2024,1,1),A2:A100,"<"&DATE(2024,2,1))**` adds up January. Also check that the dates are real dates and not text.

## **Practice SUMIFS**

- [**1****SUMIFS with two conditions**→](https://excelsavvy.com/practice/sumifs/sumifs-two-conditions)
- [**2****SUMIFS with the conditions in cells**→](https://excelsavvy.com/practice/sumifs/sumifs-criteria-from-cells)
- [**3****SUMIFS between two dates**→](https://excelsavvy.com/practice/sumifs/sumifs-between-two-dates)
- [**4****SUMIFS that leaves one value out**→](https://excelsavvy.com/practice/sumifs/sumifs-not-equal)

## **Read the guide**

- [**Excel test for a job interview: what it looks like and how to practice**](https://excelsavvy.com/learn/excel-for-job-interviews)
- [**Pivot tables explained, and the formulas that do the same job**](https://excelsavvy.com/learn/pivot-tables)
- [**Excel for finance and accounting: the skills you actually use**](https://excelsavvy.com/learn/excel-for-finance)
- [**Dates in Excel: how they work and the formulas you need**](https://excelsavvy.com/learn/excel-dates)
- [**Excel practice data: free datasets with tasks and answers**](https://excelsavvy.com/learn/excel-practice-data)
- [**Pivot table practice: 15 exercises with answers on real sales data**](https://excelsavvy.com/learn/pivot-table-practice)
- [**Excel finance data: free practice file with tasks and answers**](https://excelsavvy.com/learn/excel-finance-practice-data)

## **Questions**

<details>

<summary>

### What is the difference between SUMIF and SUMIFS?

</summary>

SUMIF takes one condition and puts the sum range last. SUMIFS takes one or more conditions and puts the sum range first.

</details>

<details>

<summary>

### How do I sum between two dates?

</summary>

Use the date column twice, with the start date in F1 and the end date in F2: =SUMIFS(C2:C100,A2:A100,"&gt;="&amp;F1,A2:A100,"&lt;="&amp;F2).

</details>

<details>

<summary>

### Can SUMIFS use OR instead of AND?

</summary>

No, the conditions are always joined with AND. When either condition may be true, add two SUMIFS: =SUMIFS(C2:C6,A2:A6,"North")+SUMIFS(C2:C6,A2:A6,"South"). SUMPRODUCT can also do it in one formula.

</details>

<details>

<summary>

### Is SUMIFS case sensitive?

</summary>

No. Text conditions ignore upper and lower case, so "north" and "North" match the same cells.

</details>

## **Related functions**

- [**SUMIF**](https://excelsavvy.com/functions/sumif)
- [**COUNTIFS**](https://excelsavvy.com/functions/countifs)
- [**AVERAGEIFS**](https://excelsavvy.com/functions/averageifs)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/functions/sumifs#webpage","dateModified":"2026-11-16","description":"How to use SUMIFS in Excel and Google Sheets: add up rows that match several conditions. Syntax, examples and a live drill.","name":"SUMIFS function in Excel: syntax and examples","url":"https://excelsavvy.com/functions/sumifs","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/functions/sumifs#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/functions/sumifs#/schema/question/1"},{"@id":"https://excelsavvy.com/functions/sumifs#/schema/question/2"},{"@id":"https://excelsavvy.com/functions/sumifs#/schema/question/3"},{"@id":"https://excelsavvy.com/functions/sumifs#/schema/question/4"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/functions/sumifs"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/functions/sumifs#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://excelsavvy.com/functions","position":2},{"@type":"ListItem","name":"SUMIFS function in Excel: syntax and examples","position":3}]},{"@id":"https://excelsavvy.com/functions/sumifs#article","dateModified":"2026-11-16","description":"How to use SUMIFS in Excel and Google Sheets: add up rows that match several conditions. Syntax, examples and a live drill.","headline":"SUMIFS function in Excel: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNSUZTIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBTVU1JRlMgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IGFkZCB1cCByb3dzIHRoYXQgbWF0Y2ggc2V2ZXJhbCBjb25kaXRpb25zLiBTeW50YXgsIGV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~U1VNSUZTKHN1bV9yYW5nZSwgY3JpdGVyaWFfcmFuZ2UxLCBjcml0ZXJpYTEsIFtjcml0ZXJpYV9yYW5nZTIsIGNyaXRlcmlhMl0sIC4uLik%2Cp_Ii9mdW5jdGlvbnMvc3VtaWZzIg%2Cs_OWFOs75w9f3gFsMh.png","@type":["Article","TechArticle"],"author":{"@id":"https://excelsavvy.com/#identity"},"image":{"@id":"https://excelsavvy.com/#/schema/image/1"},"isPartOf":{"@id":"https://excelsavvy.com/functions/sumifs#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/functions/sumifs#webpage"},"publisher":{"@id":"https://excelsavvy.com/#identity"}},{"@id":"https://excelsavvy.com/functions/sumifs#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What is the difference between SUMIF and SUMIFS?","acceptedAnswer":{"@type":"Answer","text":"SUMIF takes one condition and puts the sum range last. SUMIFS takes one or more conditions and puts the sum range first."}},{"@id":"https://excelsavvy.com/functions/sumifs#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I sum between two dates?","acceptedAnswer":{"@type":"Answer","text":"Use the date column twice, with the start date in F1 and the end date in F2: =SUMIFS(C2:C100,A2:A100,\">=\"&F1,A2:A100,\"\u003C=\"&F2)."}},{"@id":"https://excelsavvy.com/functions/sumifs#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Can SUMIFS use OR instead of AND?","acceptedAnswer":{"@type":"Answer","text":"No, the conditions are always joined with AND. When either condition may be true, add two SUMIFS: =SUMIFS(C2:C6,A2:A6,\"North\")+SUMIFS(C2:C6,A2:A6,\"South\"). SUMPRODUCT can also do it in one formula."}},{"@id":"https://excelsavvy.com/functions/sumifs#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"Is SUMIFS case sensitive?","acceptedAnswer":{"@type":"Answer","text":"No. Text conditions ignore upper and lower case, so \"north\" and \"North\" match the same cells."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"},{"@id":"https://excelsavvy.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNSUZTIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBTVU1JRlMgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IGFkZCB1cCByb3dzIHRoYXQgbWF0Y2ggc2V2ZXJhbCBjb25kaXRpb25zLiBTeW50YXgsIGV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~U1VNSUZTKHN1bV9yYW5nZSwgY3JpdGVyaWFfcmFuZ2UxLCBjcml0ZXJpYTEsIFtjcml0ZXJpYV9yYW5nZTIsIGNyaXRlcmlhMl0sIC4uLik%2Cp_Ii9mdW5jdGlvbnMvc3VtaWZzIg%2Cs_OWFOs75w9f3gFsMh.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNSUZTIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBTVU1JRlMgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IGFkZCB1cCByb3dzIHRoYXQgbWF0Y2ggc2V2ZXJhbCBjb25kaXRpb25zLiBTeW50YXgsIGV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~U1VNSUZTKHN1bV9yYW5nZSwgY3JpdGVyaWFfcmFuZ2UxLCBjcml0ZXJpYTEsIFtjcml0ZXJpYV9yYW5nZTIsIGNyaXRlcmlhMl0sIC4uLik%2Cp_Ii9mdW5jdGlvbnMvc3VtaWZzIg%2Cs_OWFOs75w9f3gFsMh.png"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
