---
title: "Add up a column with SUM | ExcelSavvy"
description: "Practice SUM in Excel: total the units in a column with =SUM(B2:B5), in a short exercise that's checked as you type."
canonical_url: "https://excelsavvy.com/practice/sum/sum-a-column"
meta:
  "og:description": "Practice SUM in Excel: total the units in a column with =SUM(B2:B5), in a short exercise that's checked as you type."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_Add%2Bup%2Ba%2Bcolumn%2Bwith%2BSUM%2Cdescription_~UHJhY3RpY2UgU1VNIGluIEV4Y2VsOiB0b3RhbCB0aGUgdW5pdHMgaW4gYSBjb2x1bW4gd2l0aCA9U1VNKEIyOkI1KSwgaW4gYSBzaG9ydCBleGVyY2lzZSB0aGF0J3MgY2hlY2tlZCBhcyB5b3UgdHlwZS4%2Ceyebrow_SUM%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiRnJ1aXQiLCJVbml0cyJdfSx7Im4iOjIsImNlbGxzIjpbIkFwcGxlIiwiMTIiXX0seyJuIjozLCJjZWxscyI6WyJQZWFyIiwiNyJdfSx7Im4iOjQsImNlbGxzIjpbIlBsdW0iLCI5Il19LHsibiI6NSwiY2VsbHMiOlsiS2l3aSIsIjQiXX0seyJuIjo2LCJjZWxscyI6WyIiLCIiXX1dLCJ0YXJnZXQiOls1LDFdfX0%2Cp_Ii9wcmFjdGljZS9zdW0vc3VtLWEtY29sdW1uIg%2Cs_z3t3m9p8sbt9cL7P.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Add up a column with SUM | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_Add%2Bup%2Ba%2Bcolumn%2Bwith%2BSUM%2Cdescription_~UHJhY3RpY2UgU1VNIGluIEV4Y2VsOiB0b3RhbCB0aGUgdW5pdHMgaW4gYSBjb2x1bW4gd2l0aCA9U1VNKEIyOkI1KSwgaW4gYSBzaG9ydCBleGVyY2lzZSB0aGF0J3MgY2hlY2tlZCBhcyB5b3UgdHlwZS4%2Ceyebrow_SUM%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiRnJ1aXQiLCJVbml0cyJdfSx7Im4iOjIsImNlbGxzIjpbIkFwcGxlIiwiMTIiXX0seyJuIjozLCJjZWxscyI6WyJQZWFyIiwiNyJdfSx7Im4iOjQsImNlbGxzIjpbIlBsdW0iLCI5Il19LHsibiI6NSwiY2VsbHMiOlsiS2l3aSIsIjQiXX0seyJuIjo2LCJjZWxscyI6WyIiLCIiXX1dLCJ0YXJnZXQiOls1LDFdfX0%2Cp_Ii9wcmFjdGljZS9zdW0vc3VtLWEtY29sdW1uIg%2Cs_z3t3m9p8sbt9cL7P.png"
---

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

# **Add up a column with SUM**

1.
2.
3.

Step 1 of 3

**SUM** adds up numbers. Instead of =B2+B3+B4+B5, you give it the whole range at once: =SUM(B2:B5).

Click **Continue** when you're ready.

Already know it? Type the formula straight into B6.

B6fx

|  | A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Fruit | Units |  |  |  | |
| 2 | Apple | 12 |  |  |  | |
| 3 | Pear | 7 |  |  |  | |
| 4 | Plum | 9 |  |  |  | |
| 5 | Kiwi | 4 |  |  |  | |
| 6 |  |  |  |  |  | |
| 7 |  |  |  |  |  | |
| 8 |  |  |  |  |  | |

Need help?

```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/sum-a-column#webpage","description":"Practice SUM in Excel: total the units in a column with =SUM(B2:B5), in a short exercise that's checked as you type.","name":"Add up a column with SUM","url":"https://excelsavvy.com/practice/sum/sum-a-column","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/sum/sum-a-column#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/sum/sum-a-column#/schema/question/1"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/sum/sum-a-column"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/sum/sum-a-column#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","item":"https://excelsavvy.com/practice/sum","position":3},{"@type":"ListItem","name":"Add up a column with SUM","position":4}]},{"@id":"https://excelsavvy.com/practice/sum/sum-a-column#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I add up a column in Excel?","acceptedAnswer":{"@type":"Answer","text":"Type =SUM( then select the cells, close the parenthesis and press Enter, for example =SUM(B2:B5)."}},{"@id":"https://excelsavvy.com/practice/sum/sum-a-column#/schema/learning-resource/1","@type":"LearningResource","description":"Practice SUM in Excel: total the units in a column with =SUM(B2:B5), in a short exercise that's checked as you type.","educationalLevel":"beginner","isAccessibleForFree":true,"learningResourceType":"exercise","name":"Add up a column with SUM","teaches":"SUM"},{"@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.
