How to Use Excel SUM Function (Examples + Video)

Learn Excel > Excel Functions > Excel SUM Function

Excel SUM Function (Example + Video)

Excel SUM Function

When to use Excel SUM Function

SUM function can be used to add all numbers in a range of cells.

What it Returns

It returns a number that represents the sum of all the numbers.

Syntax

=SUM(number1, [number2],…])

Input Arguments
  • number1 – the first number you want to add. It can be a cell reference, a cell range, or can be manually entered.
  • [number2] – (Optional) the second number you want to add. It can be a cell reference, a cell range, or can be manually entered.
Additional Notes
  • If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, or text in the array or reference are ignored
  • If any of the argument is an error, it displays an error.
Excel SUM Function – Live Example

Excel SUM Function – Video Tutorial

Related Excel Functions:
Related Articles:
Other Excel Resources: