Quick, clean, and to the point

How to use the SUM function

The SUM function is a simple function that adds up numbers.

Let's take a look.

The SUM function sums numeric values. For example, if I enter the formula =SUM(B7:B11) Excel will return "50," the total of all numbers in that range.

SUM simply ignores blank cells.

The formula =SUM(D7:E9) will return "1,350". Like blanks, SUM ignores text values.

In addition to ranges, SUM can work with individual cells, too. Just separate each additional item with a comma. As you enter these values in, you're free to combine both ranges and individual cell references.

Like other functions that accept multiple values, you can hold down the Control key (Command on a Mac) and Excel will add the commas for you each time you click a new location on the worksheet.

Here, I can use that technique to SUM all of the ranges and cells we've worked with so far.

You can select each of these values individually using the formula hint window that appears when you're editing a function. This is a good way to fix a mistake.


Related shortcuts

Dave Bruns

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas