Exceljet

Quick, clean, and to the point

Excel SUM Function

Excel SUM function
Summary 

The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments.

Purpose 
Add numbers together
Return value 
The sum of values supplied.
Syntax 
=SUM (number1, [number2], [number3], ...)
Arguments 
  • number1 - The first value to sum.
  • number2 - [optional] The second value to sum.
  • number3 - [optional] The third value to sum.
Usage notes 

The SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments.

Examples

In the example shown, the formula in D12 is:

=SUM(D6:D10) // returns 9.05

References do not need to be next to one another. For example, to sum the cost of apples, bananas, and kiwis only, you can use a formula like this:

=SUM(D6,D8,D10) // returns 5.55

Sum with text values

The SUM function automatically ignores text values without returning an error. This can can be useful in situations like this, where the first formula would otherwise throw an error.

Keyboard shortcut

Excel provides a keyboard shortcut to automatically sum a range of cells above. You can see a demonstration in this video.

Notes

  • SUM automatically ignores empty cells and cells with text values.
  • If arguments contain errors, SUM will return an error.
  • The AGGREGATE function can sum while ignoring errors.
  • SUM can handle up to 255 total arguments.
  • Arguments can be supplied as constants, ranges, named ranges, or cell references.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.