Excel: Sum Function

In Excel, the Sum function adds all numbers in a range of cells and returns the result.

The syntax for the Sum function is:

Sum( number1, number2, ... number_n )

or

Sum ( cell1:cell2 )

Applies To:

• Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Sum(B2, B3)	would return 17.7
=Sum(B3, B5, 45)	would return 57.6
=Sum(B2:B6)	would return 231.2