Excel SUM Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel SUM Function (Example + Sample File)


The Excel SUM Function is listed under Microsoft Excel's Maths Functions category. It returns the sum of the values supplied. In simple words, with SUM function you can calculate the sum of a list of values (you can directly input value into the function or refer to a range of cells.

How to use it

To learn how to use the SUM function in Excel, you need to understand its syntax and arguments: 




  • number1: A number, a range of cells that contain numbers or a single cell that contains a number.
  • [number2]: A number, a range of cells that contain numbers or a single cell that contains a number.


  • It ignores text values.


To master the SUM function we need to try it out in an example and below is one which you can try out:

You can insert numbers directly into the function by using commas between them.

You can also simply refer to a range for calculating the sum of the numbers and if there is a text, logical value or empty cell it will ignore them.

If there is an error value in a cell which you are referring to, it will return #N/A in the result.

If you have numeric values that are formatted as the text it will ignore them. It's recommended to convert them into numbers before using SUM.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.