SUM Function - Excel


Overview


The SUM function in Excel is a useful tool for adding up a range of numbers. This function will return the sum of all the numeric values within a specific range. You can provide up to 255 arguments.

An example of the SUM function in Excel

Example:

=SUM(10, 20, 30)

Syntax:

=SUM(number1, [number2], ...)

number1, number2, ...: These are the numbers or ranges that you want to add together.


Example


In the example above, the SUM function takes in cells C2 through C11 and adds them all up, which is 697.


Interactive GSheet