How to use SUM Function in Excel

Syntax

SUM(number1,[number2],…)

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

Examples

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

insert values in excel sum function

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.

sum values with excel sum function

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 error occurs

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.

excel sum function will not perform sum if values are in text format

Sample File

Remember

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