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

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment

FREE EXCEL E-BOOK

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

FREE EXCEL E-BOOK

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

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

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