---
title: "SUMIFS in Google Sheets: practice exercises | ExcelSavvy"
description: "Practice SUMIFS in Google Sheets: add up the rows that meet several conditions, in exercises that are checked as you type."
canonical_url: "https://excelsavvy.com/sheets/practice/sumifs"
meta:
  "og:description": "Practice SUMIFS in Google Sheets: add up the rows that meet several conditions, in exercises that are checked as you type."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNSUZTIGluIEdvb2dsZSBTaGVldHM6IHByYWN0aWNlIGV4ZXJjaXNlcw%2Cdescription_~UHJhY3RpY2UgU1VNSUZTIGluIEdvb2dsZSBTaGVldHM6IGFkZCB1cCB0aGUgcm93cyB0aGF0IG1lZXQgc2V2ZXJhbCBjb25kaXRpb25zLCBpbiBleGVyY2lzZXMgdGhhdCBhcmUgY2hlY2tlZCBhcyB5b3UgdHlwZS4%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJSZWdpb24iLCJQcm9kdWN0IiwiU2FsZXMiLCJOb3J0aCBzaG9lcyJdfSx7Im4iOjIsImNlbGxzIjpbIk5vcnRoIiwiU2hvZXMiLCI1MDAiLCIiXX0seyJuIjozLCJjZWxscyI6WyJTb3V0aCIsIlNob2VzIiwiMzAwIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiTm9ydGgiLCJCYWdzIiwiMjUwIiwiIl19LHsibiI6NSwiY2VsbHMiOlsiTm9ydGgiLCJTaG9lcyIsIjQyMCIsIiJdfSx7Im4iOjYsImNlbGxzIjpbIlNvdXRoIiwiQmFncyIsIjE4MCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9zaGVldHMvcHJhY3RpY2Uvc3VtaWZzIg%2Cs_Nni0QzDh0mXaPoHH.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "SUMIFS in Google Sheets: practice exercises | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNSUZTIGluIEdvb2dsZSBTaGVldHM6IHByYWN0aWNlIGV4ZXJjaXNlcw%2Cdescription_~UHJhY3RpY2UgU1VNSUZTIGluIEdvb2dsZSBTaGVldHM6IGFkZCB1cCB0aGUgcm93cyB0aGF0IG1lZXQgc2V2ZXJhbCBjb25kaXRpb25zLCBpbiBleGVyY2lzZXMgdGhhdCBhcmUgY2hlY2tlZCBhcyB5b3UgdHlwZS4%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJSZWdpb24iLCJQcm9kdWN0IiwiU2FsZXMiLCJOb3J0aCBzaG9lcyJdfSx7Im4iOjIsImNlbGxzIjpbIk5vcnRoIiwiU2hvZXMiLCI1MDAiLCIiXX0seyJuIjozLCJjZWxscyI6WyJTb3V0aCIsIlNob2VzIiwiMzAwIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiTm9ydGgiLCJCYWdzIiwiMjUwIiwiIl19LHsibiI6NSwiY2VsbHMiOlsiTm9ydGgiLCJTaG9lcyIsIjQyMCIsIiJdfSx7Im4iOjYsImNlbGxzIjpbIlNvdXRoIiwiQmFncyIsIjE4MCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9zaGVldHMvcHJhY3RpY2Uvc3VtaWZzIg%2Cs_Nni0QzDh0mXaPoHH.png"
---

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

# **SUMIFS practice in Google Sheets**

SUMIFS takes the sum range first and then pairs of range and criterion, in Google Sheets exactly as in Excel. Every condition must hold for a row to count.

[**Start the first exercise**](https://excelsavvy.com/sheets/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/sheets/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/sheets/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/sheets/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/sheets/practice/sumifs/sumifs-not-equal)

## **Functions in this topic**

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

## **Questions**

<details>

<summary>

### What is the difference between SUMIF and SUMIFS in Google Sheets?

</summary>

SUMIFS can check several conditions, and it takes the sum range first. SUMIF checks one condition and takes the sum range last. Both work as in Excel.

</details>

<details>

<summary>

### How do I sum between two dates with SUMIFS in Google Sheets?

</summary>

Use the date column twice, as in =SUMIFS(C2:C9,A2:A9,"&gt;="&amp;F1,A2:A9,"&lt;="&amp;F2). Both limits must be real dates, not text. Dates that sit at the left edge of a cell are usually text, and SUMIFS will not match them. Retype them or reformat them as dates.

</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/sheets/practice/sumifs#webpage","description":"Practice SUMIFS in Google Sheets: add up the rows that meet several conditions, in exercises that are checked as you type.","name":"SUMIFS in Google Sheets: practice exercises","url":"https://excelsavvy.com/sheets/practice/sumifs","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/sheets/practice/sumifs#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/sheets/practice/sumifs#/schema/question/1"},{"@id":"https://excelsavvy.com/sheets/practice/sumifs#/schema/question/2"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/sheets/practice/sumifs"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/sheets/practice/sumifs#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Google Sheets practice exercises","item":"https://excelsavvy.com/sheets","position":2},{"@type":"ListItem","name":"SUMIFS in Google Sheets: practice exercises","position":3}]},{"@id":"https://excelsavvy.com/sheets/practice/sumifs#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What is the difference between SUMIF and SUMIFS in Google Sheets?","acceptedAnswer":{"@type":"Answer","text":"SUMIFS can check several conditions, and it takes the sum range first. SUMIF checks one condition and takes the sum range last. Both work as in Excel."}},{"@id":"https://excelsavvy.com/sheets/practice/sumifs#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I sum between two dates with SUMIFS in Google Sheets?","acceptedAnswer":{"@type":"Answer","text":"Use the date column twice, as in =SUMIFS(C2:C9,A2:A9,\">=\"&F1,A2:A9,\"\u003C=\"&F2). Both limits must be real dates, not text. Dates that sit at the left edge of a cell are usually text, and SUMIFS will not match them. Retype them or reformat them as dates."}},{"@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.
