Exceljet

Quick, clean, and to the point

Excel SUM Function

Excel SUM function
Summary 

The Excel SUM function returns the sum of values supplied as multiple arguments. SUM can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.

Purpose 
Add numbers together
Return value 
The sum of values supplied.
Syntax 
=SUM (number1, [number2], [number3], ...)
Arguments 
  • number1 - The first item to sum.
  • number2 - [optional] The second item to sum.
  • number3 - [optional] The third item to sum.
Usage notes 
  • The SUM function sums values supplied as arguments (up to 255 arguments).
  • Arguments can be supplied as numbers, cell references, ranges, arrays, constants, and the results of other formulas or functions.
  • For example, SUM(C1:C3) adds all the numbers that are contained in cells C1 through C3, which is equivalent to SUM (C1, C2, C3)

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.