HomeExcel Functions ► Excel SUM Function

Syntax For Excel SUM Function

What is the use of Excel SUM Function?

Use Excel SUM Function to sum numeric values. In simple words, You can use this function to sum numbers. SUM function is the most used function in excel.

Syntax for Excel SUM Function

SUM(number1,[number2],…)

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

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

More Information on Excel SUM Function

  • You can specify non-continues ranges to sum by differentiating them by using commas.
  • You can also insert numbers directly into the function.
  • You can also use the shortcut key ALT + = to sum cells.

Shortcut Key To Insert Excel SUM Function in Excel

Examples to understand Excel SUM Function

Insert Vallues In Excel SUM Function

As I have already mentioned that you can insert numbers directly into the function by using commas between them.

SumValues With Excel Sum Function

You can simply refer to a range for calculating the sum of the numbers in those cells. And if there are text, logical values or empty cells it will ignore them.

Excel Sum Function Will Not Perform Sum If Error Occurs

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

Excel Sum Function Will Not Perform Sum If Values are in text format

If you have numeric values which are formatted as text if will ignore them. It is recommended to format them into number format before using SUM Function.

Download Sample File

Download Sample File To Learn Excel SUM Function

More Tips Related With Excel SUM Function

Conclusion

Use Excel SUM Function to sum numeric values. Learn more about SUM from here.

Related Function

Count | Average | SumIf | SumIfs

Blog | Excel Functions