---
title: "SUM practice exercises | PracticeExcel"
description: "Practice SUM in a live spreadsheet: add a column, several ranges and use AutoSum."
canonical_url: "https://practiceexcelonline.com/practice/sum"
locale: en
meta:
  "og:description": "Practice SUM in a live spreadsheet: add a column, several ranges and use AutoSum."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_SUM%2Bpractice%2Bexercises%2Cdescription_~UHJhY3RpY2UgU1VNIGluIGEgbGl2ZSBzcHJlYWRzaGVldDogYWRkIGEgY29sdW1uLCBzZXZlcmFsIHJhbmdlcyBhbmQgdXNlIEF1dG9TdW0u%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiRnJ1aXQiLCJVbml0cyJdfSx7Im4iOjIsImNlbGxzIjpbIkFwcGxlIiwiMTIiXX0seyJuIjozLCJjZWxscyI6WyJQZWFyIiwiNyJdfSx7Im4iOjQsImNlbGxzIjpbIlBsdW0iLCI5Il19LHsibiI6NSwiY2VsbHMiOlsiS2l3aSIsIjQiXX0seyJuIjo2LCJjZWxscyI6WyIiLCIiXX1dLCJ0YXJnZXQiOls1LDFdfX0%2Cp_Ii9wcmFjdGljZS9zdW0i%2Cs_Wv_K2evijTYnOpo6.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "SUM practice exercises | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_SUM%2Bpractice%2Bexercises%2Cdescription_~UHJhY3RpY2UgU1VNIGluIGEgbGl2ZSBzcHJlYWRzaGVldDogYWRkIGEgY29sdW1uLCBzZXZlcmFsIHJhbmdlcyBhbmQgdXNlIEF1dG9TdW0u%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiRnJ1aXQiLCJVbml0cyJdfSx7Im4iOjIsImNlbGxzIjpbIkFwcGxlIiwiMTIiXX0seyJuIjozLCJjZWxscyI6WyJQZWFyIiwiNyJdfSx7Im4iOjQsImNlbGxzIjpbIlBsdW0iLCI5Il19LHsibiI6NSwiY2VsbHMiOlsiS2l3aSIsIjQiXX0seyJuIjo2LCJjZWxscyI6WyIiLCIiXX1dLCJ0YXJnZXQiOls1LDFdfX0%2Cp_Ii9wcmFjdGljZS9zdW0i%2Cs_Wv_K2evijTYnOpo6.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.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://practiceexcelonline.com/practice/sum/sum-a-column)

SUM(

1. [**1****Add up a column with SUM**In B6, use SUM to total the Units in B2:B5.](https://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.com/practice/sum/sum-ignores-text)

## **Functions in this topic**

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

## **Read the guide**

- [**Excel for job interviews: what gets tested and how to prepare**](https://practiceexcelonline.com/learn/excel-for-job-interviews)
- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://practiceexcelonline.com/learn/how-to-learn-excel)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/practice/sum#webpage","description":"Practice SUM in a live spreadsheet: add a column, several ranges and use AutoSum.","name":"SUM practice exercises","url":"https://practiceexcelonline.com/practice/sum","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/practice/sum#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/sum"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/sum#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://practiceexcelonline.com/practice","position":2},{"@type":"ListItem","name":"SUM practice exercises","position":3}]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

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