---
title: "SUMIFS practice: 4 exercises with answers | ExcelSavvy"
description: "Practice SUMIFS in Excel: total rows with two conditions, conditions in cells, between two dates, or leaving one value out. Checked instantly."
canonical_url: "https://excelsavvy.com/practice/sumifs"
meta:
  "og:description": "Practice SUMIFS in Excel: total rows with two conditions, conditions in cells, between two dates, or leaving one value out. Checked instantly."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNSUZTIHByYWN0aWNlOiA0IGV4ZXJjaXNlcyB3aXRoIGFuc3dlcnM%2Cdescription_~UHJhY3RpY2UgU1VNSUZTIGluIEV4Y2VsOiB0b3RhbCByb3dzIHdpdGggdHdvIGNvbmRpdGlvbnMsIGNvbmRpdGlvbnMgaW4gY2VsbHMsIGJldHdlZW4gdHdvIGRhdGVzLCBvciBsZWF2aW5nIG9uZSB2YWx1ZSBvdXQuIENoZWNrZWQgaW5zdGFudGx5Lg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJSZWdpb24iLCJQcm9kdWN0IiwiU2FsZXMiLCJOb3J0aCBzaG9lcyJdfSx7Im4iOjIsImNlbGxzIjpbIk5vcnRoIiwiU2hvZXMiLCI1MDAiLCIiXX0seyJuIjozLCJjZWxscyI6WyJTb3V0aCIsIlNob2VzIiwiMzAwIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiTm9ydGgiLCJCYWdzIiwiMjUwIiwiIl19LHsibiI6NSwiY2VsbHMiOlsiTm9ydGgiLCJTaG9lcyIsIjQyMCIsIiJdfSx7Im4iOjYsImNlbGxzIjpbIlNvdXRoIiwiQmFncyIsIjE4MCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9wcmFjdGljZS9zdW1pZnMi%2Cs_1aRBgVIDcgWLMUew.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "SUMIFS practice: 4 exercises with answers | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNSUZTIHByYWN0aWNlOiA0IGV4ZXJjaXNlcyB3aXRoIGFuc3dlcnM%2Cdescription_~UHJhY3RpY2UgU1VNSUZTIGluIEV4Y2VsOiB0b3RhbCByb3dzIHdpdGggdHdvIGNvbmRpdGlvbnMsIGNvbmRpdGlvbnMgaW4gY2VsbHMsIGJldHdlZW4gdHdvIGRhdGVzLCBvciBsZWF2aW5nIG9uZSB2YWx1ZSBvdXQuIENoZWNrZWQgaW5zdGFudGx5Lg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJSZWdpb24iLCJQcm9kdWN0IiwiU2FsZXMiLCJOb3J0aCBzaG9lcyJdfSx7Im4iOjIsImNlbGxzIjpbIk5vcnRoIiwiU2hvZXMiLCI1MDAiLCIiXX0seyJuIjozLCJjZWxscyI6WyJTb3V0aCIsIlNob2VzIiwiMzAwIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiTm9ydGgiLCJCYWdzIiwiMjUwIiwiIl19LHsibiI6NSwiY2VsbHMiOlsiTm9ydGgiLCJTaG9lcyIsIjQyMCIsIiJdfSx7Im4iOjYsImNlbGxzIjpbIlNvdXRoIiwiQmFncyIsIjE4MCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9wcmFjdGljZS9zdW1pZnMi%2Cs_1aRBgVIDcgWLMUew.png"
---

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

# **SUMIFS practice exercises**

Add up rows that meet several conditions at once, such as a region and a minimum amount. Note that the sum range comes first.

[**Start the first exercise**](https://excelsavvy.com/practice/sumifs/sumifs-two-conditions)

SUMIFS(

## **How SUMIFS works**

SUMIFS adds up the numbers in the rows where every one of your conditions is met. You give it the sum range first, then a pair for each condition: a range to test and a criterion. It works the same in Excel and Google Sheets.

`**=SUMIFS(C2:C9,A2:A9,"North",B2:B9,"Shoes")**` totals the sales of shoes in the North region. For a period, use the date column twice: `**">="&F1**` and `**"<="&F2**` give you the dates from F1 to F2, both days included. To leave one value out, use `**"<>Returned"**` as the criterion.

Mind the order: the sum range comes first in SUMIFS but last in SUMIF, so a formula copied from one to the other breaks quietly. All the conditions must be true at the same time. The exercises below cover two conditions, conditions taken from cells, sums between two dates, and leaving one value out.

1. [**1****SUMIFS with two conditions**In E2, use SUMIFS to total the Sales of Shoes in the North region.](https://excelsavvy.com/practice/sumifs/sumifs-two-conditions)
2. [**2****SUMIFS with the conditions in cells****Premium**In G2, use SUMIFS to total the Sales for the region in E2 and the product in F2. Point at the cells instead of typing the words.](https://excelsavvy.com/practice/sumifs/sumifs-criteria-from-cells)
3. [**3****SUMIFS between two dates****Premium**In F3, total the amounts of the orders dated from F1 to F2, both days included. Give SUMIFS the date column twice: ">="&F1 and "<="&F2.](https://excelsavvy.com/practice/sumifs/sumifs-between-two-dates)
4. [**4****SUMIFS that leaves one value out****Premium**In F1, total the North orders that were not returned. Give SUMIFS two conditions: the region "North" and the status "<>Returned".](https://excelsavvy.com/practice/sumifs/sumifs-not-equal)

## **Functions in this topic**

- [**SUMIFS**](https://excelsavvy.com/functions/sumifs)

## **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)
- [**Excel practice data: free datasets with tasks and answers**](https://excelsavvy.com/learn/excel-practice-data)
- [**Excel finance data: free practice file with tasks and answers**](https://excelsavvy.com/learn/excel-finance-practice-data)
- [**Best advanced Excel courses in 2026: what to learn and where**](https://excelsavvy.com/learn/best-advanced-excel-courses)

## **Questions**

<details>

<summary>

### How do I use SUMIFS with OR logic?

</summary>

SUMIFS only combines conditions with AND. For OR, add one SUMIFS per option, as in =SUMIFS(D2:D20,B2:B20,"North")+SUMIFS(D2:D20,B2:B20,"South"). That works when the options exclude each other, such as two regions. If one row can match both, the row would be counted twice.

</details>

<details>

<summary>

### Why does SUMIFS return #VALUE!?

</summary>

The sum range and every criteria range must have the same number of rows and columns. If one is B2:B10 and another is A2:A9, SUMIFS gives #VALUE!. Check the ranges one by one. The same error appears if a range points to a closed workbook.

</details>

<details>

<summary>

### How do I sum cells that contain certain text with SUMIFS?

</summary>

Put wildcards around the word, as in =SUMIFS(D2:D20,A2:A20,"\*desk\*",C2:C20,"North"). The \* stands for any number of characters, and ? stands for exactly one. The match ignores upper and lower case. Put the wildcard text in quotes, or join it to a cell with &amp;.

</details>

```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/practice/sumifs#webpage","description":"Practice SUMIFS in Excel: total rows with two conditions, conditions in cells, between two dates, or leaving one value out. Checked instantly.","name":"SUMIFS practice: 4 exercises with answers","url":"https://excelsavvy.com/practice/sumifs","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/sumifs#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/sumifs#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/sumifs#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/sumifs#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/sumifs"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/sumifs#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"SUMIFS practice: 4 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/sumifs#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I use SUMIFS with OR logic?","acceptedAnswer":{"@type":"Answer","text":"SUMIFS only combines conditions with AND. For OR, add one SUMIFS per option, as in =SUMIFS(D2:D20,B2:B20,\"North\")+SUMIFS(D2:D20,B2:B20,\"South\"). That works when the options exclude each other, such as two regions. If one row can match both, the row would be counted twice."}},{"@id":"https://excelsavvy.com/practice/sumifs#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Why does SUMIFS return #VALUE!?","acceptedAnswer":{"@type":"Answer","text":"The sum range and every criteria range must have the same number of rows and columns. If one is B2:B10 and another is A2:A9, SUMIFS gives #VALUE!. Check the ranges one by one. The same error appears if a range points to a closed workbook."}},{"@id":"https://excelsavvy.com/practice/sumifs#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I sum cells that contain certain text with SUMIFS?","acceptedAnswer":{"@type":"Answer","text":"Put wildcards around the word, as in =SUMIFS(D2:D20,A2:A20,\"*desk*\",C2:C20,\"North\"). The * stands for any number of characters, and ? stands for exactly one. The match ignores upper and lower case. Put the wildcard text in quotes, or join it to a cell with &."}},{"@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"}]}
```

## Sitemap

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