How to Use Excel SUM Function (Examples + Video)

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:

You May Also Like the Following Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster