What is EXCEL SUM FUNCTION
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.
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 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 ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.