---
title: "SUMIF practice: 5 exercises with answers | ExcelSavvy"
description: "Practice SUMIF in Excel with text and number conditions, a separate sum_range, a criterion in a cell and wildcards, checked as you type."
canonical_url: "https://excelsavvy.com/practice/sumif"
meta:
  "og:description": "Practice SUMIF in Excel with text and number conditions, a separate sum_range, a criterion in a cell and wildcards, checked as you type."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNSUYgcHJhY3RpY2U6IDUgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~UHJhY3RpY2UgU1VNSUYgaW4gRXhjZWwgd2l0aCB0ZXh0IGFuZCBudW1iZXIgY29uZGl0aW9ucywgYSBzZXBhcmF0ZSBzdW1fcmFuZ2UsIGEgY3JpdGVyaW9uIGluIGEgY2VsbCBhbmQgd2lsZGNhcmRzLCBjaGVja2VkIGFzIHlvdSB0eXBlLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIkZydWl0IiwiVW5pdHMiLCIiXX0seyJuIjoyLCJjZWxscyI6WyJBcHBsZSIsIjUiLCIiXX0seyJuIjozLCJjZWxscyI6WyJQZWFyIiwiMyIsIiJdfSx7Im4iOjQsImNlbGxzIjpbIkFwcGxlIiwiOCIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIlBsdW0iLCIyIiwiIl19LHsibiI6NiwiY2VsbHMiOlsiQXBwbGUiLCI0IiwiIl19XSwidGFyZ2V0IjpbMSwyXX19%2Cp_Ii9wcmFjdGljZS9zdW1pZiI%2Cs_ITSblMcknuTqOcqF.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "SUMIF practice: 5 exercises with answers | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNSUYgcHJhY3RpY2U6IDUgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~UHJhY3RpY2UgU1VNSUYgaW4gRXhjZWwgd2l0aCB0ZXh0IGFuZCBudW1iZXIgY29uZGl0aW9ucywgYSBzZXBhcmF0ZSBzdW1fcmFuZ2UsIGEgY3JpdGVyaW9uIGluIGEgY2VsbCBhbmQgd2lsZGNhcmRzLCBjaGVja2VkIGFzIHlvdSB0eXBlLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIkZydWl0IiwiVW5pdHMiLCIiXX0seyJuIjoyLCJjZWxscyI6WyJBcHBsZSIsIjUiLCIiXX0seyJuIjozLCJjZWxscyI6WyJQZWFyIiwiMyIsIiJdfSx7Im4iOjQsImNlbGxzIjpbIkFwcGxlIiwiOCIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIlBsdW0iLCIyIiwiIl19LHsibiI6NiwiY2VsbHMiOlsiQXBwbGUiLCI0IiwiIl19XSwidGFyZ2V0IjpbMSwyXX19%2Cp_Ii9wcmFjdGljZS9zdW1pZiI%2Cs_ITSblMcknuTqOcqF.png"
---

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

# **SUMIF practice exercises**

Add up only the rows that meet a condition, with the condition in the same column or in another one.

[**Start the first exercise**](https://excelsavvy.com/practice/sumif/sumif-text-criteria)

SUMIF(

## **How SUMIF works**

SUMIF adds up the numbers in the rows that meet one condition. It takes three arguments: the range to test, the condition, and the range to add up.

`**=SUMIF($B$2:$B$100,"North",$D$2:$D$100)**` adds the sales in column D for every row where the region in column B is North. Put the condition in a cell instead, as in `**=SUMIF($B$2:$B$100,F2,$D$2:$D$100)**`, and you can copy the formula down a list of regions to build a summary table.

Conditions can be text, a number, a comparison in quotes such as `**">500"**`, or a wildcard such as `**"*desk*"**` for any text that contains desk. With two or more conditions, use SUMIFS. The exercises below cover text and number conditions, conditions from a cell, wildcards, and summing one column while testing another.

1. [**1****SUMIF with a text criterion**In D2, use SUMIF to total the Units sold of Apple.](https://excelsavvy.com/practice/sumif/sumif-text-criteria)
2. [**2****SUMIF with a number condition****Premium**In D2, use SUMIF to total the amounts greater than 100.](https://excelsavvy.com/practice/sumif/sumif-greater-than)
3. [**3****SUMIF with a separate sum\_range****Premium**In E2, use SUMIF to total the Amount of orders with more than 3 units.](https://excelsavvy.com/practice/sumif/sumif-with-sum-range)
4. [**4****SUMIF with the criterion in a cell****Premium**In E2, total the Sales of the rep named in D2. Point SUMIF at D2 instead of typing the name, so the total follows when D2 changes.](https://excelsavvy.com/practice/sumif/sumif-criteria-from-a-cell)
5. [**5****SUMIF with a wildcard****Premium**In E1, total the sales of every product with Chair anywhere in its name. Use \* on both sides of the word: SUMIF(A2:A8,"\*Chair\*",B2:B8).](https://excelsavvy.com/practice/sumif/sumif-wildcard-contains)

## **Functions in this topic**

- [**SUMIF**](https://excelsavvy.com/functions/sumif)

## **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)
- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)
- [**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 budget template: free download and the formulas behind it**](https://excelsavvy.com/learn/excel-budget-template)
- [**Excel inventory data: free practice file with tasks and answers**](https://excelsavvy.com/learn/excel-inventory-data)
- [**Excel customer data: free practice file with tasks and answers**](https://excelsavvy.com/learn/excel-customer-data)
- [**Excel finance data: free practice file with tasks and answers**](https://excelsavvy.com/learn/excel-finance-practice-data)
- [**Best Excel courses online in 2026: 10 places to learn Excel, ranked**](https://excelsavvy.com/learn/best-places-to-learn-excel)
- [**Udemy vs Coursera vs LinkedIn Learning for Excel: which to pick**](https://excelsavvy.com/learn/udemy-vs-coursera-vs-linkedin-learning-excel)

## **Questions**

<details>

<summary>

### How do I use SUMIF with multiple criteria?

</summary>

Use SUMIFS instead. It takes the sum range first, then a range and a criterion for each condition, as in =SUMIFS(D2:D10,B2:B10,"North",C2:C10,"&gt;100"). Every condition must be true for a row to count. If you want rows that match one condition or the other, add two SUMIF formulas together.

</details>

<details>

<summary>

### How do I use SUMIF with dates?

</summary>

Put the comparison in quotes and join the date with &amp;, as in =SUMIF(A2:A10,"&gt;="&amp;F1,B2:B10), which adds the amounts dated on or after the date in F1. SUMIF can test only one limit. To sum between two dates, use SUMIFS with the date column twice.

</details>

<details>

<summary>

### Why does SUMIF return 0?

</summary>

Usually no row matches the criterion. Check for extra spaces and typos in the criterion. If the numbers in the sum range are stored as text, SUMIF skips them and you also get 0. Numbers that sit at the left edge of a cell are often text.

</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/sumif#webpage","description":"Practice SUMIF in Excel with text and number conditions, a separate sum_range, a criterion in a cell and wildcards, checked as you type.","name":"SUMIF practice: 5 exercises with answers","url":"https://excelsavvy.com/practice/sumif","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/sumif#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/sumif#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/sumif#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/sumif#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/sumif"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/sumif#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":"SUMIF practice: 5 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/sumif#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I use SUMIF with multiple criteria?","acceptedAnswer":{"@type":"Answer","text":"Use SUMIFS instead. It takes the sum range first, then a range and a criterion for each condition, as in =SUMIFS(D2:D10,B2:B10,\"North\",C2:C10,\">100\"). Every condition must be true for a row to count. If you want rows that match one condition or the other, add two SUMIF formulas together."}},{"@id":"https://excelsavvy.com/practice/sumif#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I use SUMIF with dates?","acceptedAnswer":{"@type":"Answer","text":"Put the comparison in quotes and join the date with &, as in =SUMIF(A2:A10,\">=\"&F1,B2:B10), which adds the amounts dated on or after the date in F1. SUMIF can test only one limit. To sum between two dates, use SUMIFS with the date column twice."}},{"@id":"https://excelsavvy.com/practice/sumif#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Why does SUMIF return 0?","acceptedAnswer":{"@type":"Answer","text":"Usually no row matches the criterion. Check for extra spaces and typos in the criterion. If the numbers in the sum range are stored as text, SUMIF skips them and you also get 0. Numbers that sit at the left edge of a cell are often text."}},{"@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.
