SUM function is one of the most useful functions in Excel. You can use it to sum values. In simple words, you can use this function to sum numbers.

SUM(number1,[number2],…)

*number1**A number, a range of cells which contain numbers or a single cell which contain a number.***[number2]**A number, a range of cells which contain numbers or a single cell which contain a number.

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 text, logical values or empty cells in those cells it will ignore them.

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

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

Download this sample file from here to learn more.

- It can take up to 255 arguments.
- Arguments can be numbers, cell references, ranges, arrays, constants, and the results of other formulas or functions.

*This function is the part of our **top 100 functions list** and here are some **useful formulas** which you can learn today.*

Related Functions

- SUMIF Function: It returns the sum of the numeric values of which meet a condition. You need to specify a condition and [...]
- SUMIFS Function: It returns the sum of the numeric values of which meet multiple conditions. You need to specify conditions and [...]
- SUMPRODUCT Function: It multiplies values from corresponding cells in the given arrays, and returns the sum [...]

Related Excel Tutorials

- SUMIF Between Dates: You can use SUMIF to sum values between two dates using them as a range criteria [...]
- SUMIF OR: SUMIF OR helps use to sum for more than one criteria at the same time which is not possible in normal SUMIF [...]
- SUMPRODUCT IF: And you know the best part? There is no need to use IF function for this. But first [...]