---
title: "SUM practice: 4 exercises with answers | ExcelSavvy"
description: "Practice SUM in Excel: add up a column, a block of cells and two separate ranges, and see how SUM skips text. Checked as you type."
canonical_url: "https://excelsavvy.com/practice/sum"
meta:
  "og:description": "Practice SUM in Excel: add up a column, a block of cells and two separate ranges, and see how SUM skips text. Checked as you type."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNIHByYWN0aWNlOiA0IGV4ZXJjaXNlcyB3aXRoIGFuc3dlcnM%2Cdescription_~UHJhY3RpY2UgU1VNIGluIEV4Y2VsOiBhZGQgdXAgYSBjb2x1bW4sIGEgYmxvY2sgb2YgY2VsbHMgYW5kIHR3byBzZXBhcmF0ZSByYW5nZXMsIGFuZCBzZWUgaG93IFNVTSBza2lwcyB0ZXh0LiBDaGVja2VkIGFzIHlvdSB0eXBlLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiRnJ1aXQiLCJVbml0cyJdfSx7Im4iOjIsImNlbGxzIjpbIkFwcGxlIiwiMTIiXX0seyJuIjozLCJjZWxscyI6WyJQZWFyIiwiNyJdfSx7Im4iOjQsImNlbGxzIjpbIlBsdW0iLCI5Il19LHsibiI6NSwiY2VsbHMiOlsiS2l3aSIsIjQiXX0seyJuIjo2LCJjZWxscyI6WyIiLCIiXX1dLCJ0YXJnZXQiOls1LDFdfX0%2Cp_Ii9wcmFjdGljZS9zdW0i%2Cs_ICr3-BwEMTiYa8NA.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "SUM practice: 4 exercises with answers | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~U1VNIHByYWN0aWNlOiA0IGV4ZXJjaXNlcyB3aXRoIGFuc3dlcnM%2Cdescription_~UHJhY3RpY2UgU1VNIGluIEV4Y2VsOiBhZGQgdXAgYSBjb2x1bW4sIGEgYmxvY2sgb2YgY2VsbHMgYW5kIHR3byBzZXBhcmF0ZSByYW5nZXMsIGFuZCBzZWUgaG93IFNVTSBza2lwcyB0ZXh0LiBDaGVja2VkIGFzIHlvdSB0eXBlLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiRnJ1aXQiLCJVbml0cyJdfSx7Im4iOjIsImNlbGxzIjpbIkFwcGxlIiwiMTIiXX0seyJuIjozLCJjZWxscyI6WyJQZWFyIiwiNyJdfSx7Im4iOjQsImNlbGxzIjpbIlBsdW0iLCI5Il19LHsibiI6NSwiY2VsbHMiOlsiS2l3aSIsIjQiXX0seyJuIjo2LCJjZWxscyI6WyIiLCIiXX1dLCJ0YXJnZXQiOls1LDFdfX0%2Cp_Ii9wcmFjdGljZS9zdW0i%2Cs_ICr3-BwEMTiYa8NA.png"
---

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

# **SUM practice exercises**

Add up a column or a range with SUM, the first function everyone learns. These drills cover a single column, several ranges and the AutoSum shortcut.

[**Start the first exercise**](https://excelsavvy.com/practice/sum/sum-a-column)

SUM(

## **How SUM works**

SUM adds up numbers. Give it one or more arguments, and each one can be a single cell, a range or a plain number. Excel accepts up to 255 arguments.

`**=SUM(B2:B5)**` adds the four cells in the range, so units of 12, 8, 15 and 5 return 40. When the numbers sit in two places, give SUM two ranges: `**=SUM(B2:B3,E2:E3)**`. To total a whole block, use one range that covers it, like `**=SUM(B2:D4)**`.

SUM skips text inside a range, so a cell that says "n/a" doesn't break the total. Adding the cells with plus does: `**=B2+B3**` returns #VALUE! as soon as one of them is text. Watch out for numbers stored as text, though. SUM skips those too, and the total comes out too low. The exercises below cover a single column, a block of several columns, two separate ranges and a range that contains text.

1. [**1****Add up a column with SUM**In B6, use SUM to total the Units in B2:B5.](https://excelsavvy.com/practice/sum/sum-a-column)
2. [**2****SUM a block of cells**In F2, total the sales of every region in every quarter with one SUM over B2:D4.](https://excelsavvy.com/practice/sum/sum-a-block-of-cells)
3. [**3****SUM two separate ranges**In G2, add up Rent and Fun for both months. They are not next to each other, so give SUM two ranges separated by a comma.](https://excelsavvy.com/practice/sum/sum-separate-ranges)
4. [**4****SUM skips text that + can't**In B7, add up the sales in B2:B6. Aalborg hasn't reported yet and says n/a, so use SUM, which skips text, rather than adding the cells with +.](https://excelsavvy.com/practice/sum/sum-ignores-text)

## **Functions in this topic**

- [**SUM**](https://excelsavvy.com/functions/sum)

## **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)

## **Questions**

<details>

<summary>

### How do I add up a column in Excel without typing the range?

</summary>

Select the cell right below the numbers and click AutoSum on the Home tab, or press Alt+=. Excel suggests the range of numbers above, and you confirm with Enter. AutoSum stops at the first empty cell, so check that the highlighted range covers everything before you press Enter.

</details>

<details>

<summary>

### Why does SUM show 0 or a total that is too low?

</summary>

The numbers are probably stored as text, and SUM skips text. They often sit on the left side of the cell and have a small green triangle in the corner. Select the cells, click the warning icon and choose Convert to Number. Once they are real numbers, SUM counts them again.

</details>

<details>

<summary>

### How do I sum the same cell across several sheets?

</summary>

Use a 3D reference: =SUM(Jan:Mar!B2) adds cell B2 from every sheet between Jan and Mar, including the ones in the middle. The sheets must sit next to each other in the tab bar. If you drag a sheet out of that stretch, it drops out of the total.

</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/sum#webpage","description":"Practice SUM in Excel: add up a column, a block of cells and two separate ranges, and see how SUM skips text. Checked as you type.","name":"SUM practice: 4 exercises with answers","url":"https://excelsavvy.com/practice/sum","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/sum#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/sum#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/sum#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/sum#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/sum"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/sum#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":"SUM practice: 4 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/sum#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I add up a column in Excel without typing the range?","acceptedAnswer":{"@type":"Answer","text":"Select the cell right below the numbers and click AutoSum on the Home tab, or press Alt+=. Excel suggests the range of numbers above, and you confirm with Enter. AutoSum stops at the first empty cell, so check that the highlighted range covers everything before you press Enter."}},{"@id":"https://excelsavvy.com/practice/sum#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Why does SUM show 0 or a total that is too low?","acceptedAnswer":{"@type":"Answer","text":"The numbers are probably stored as text, and SUM skips text. They often sit on the left side of the cell and have a small green triangle in the corner. Select the cells, click the warning icon and choose Convert to Number. Once they are real numbers, SUM counts them again."}},{"@id":"https://excelsavvy.com/practice/sum#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I sum the same cell across several sheets?","acceptedAnswer":{"@type":"Answer","text":"Use a 3D reference: =SUM(Jan:Mar!B2) adds cell B2 from every sheet between Jan and Mar, including the ones in the middle. The sheets must sit next to each other in the tab bar. If you drag a sheet out of that stretch, it drops out of the total."}},{"@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.
