Microsoft Excel SUM Function Help

SUM Function Examples

• Click to view SUM function examples

SUM Function Definition

Adds all the numbers in a range of cells. Capable of adding 30 separate ranges, cells and/or numbers together

Sum Function Syntax

=SUM(number1,[number2], ...,[number30])

[] bracket means argument is optional which means you do not have to fill the slot.

SUM Function Argument Definitions

number1, number2, ...number30:   These are 1 to 30 arguments for which you want the total value or sum. Replace each argument with a number, a cell reference, range reference, cell name, range name, function or formula that generates a number.

SUM Function Tips

• Numbers, TRUE,  FALSE and text representations of numbers that are typed directly into the SUM function argument list are counted.
• If using a range, only numbers in that range are counted. Empty cells, TRUE, FALSE or numbers displayed as text in the range are ignored.
• References (cell or ranges) or formulas that produce error values or text that cannot be translated into numbers will cause an error.