SUM Function and Various Methods

Welcome to the Microsoft Excel.

This Excel tutorial explains how to use the Excel SUM function step-by-step with syntax and examples.



Description
The Microsoft Excel SUM function adds all numbers in a range of cells and returns the result.

The SUM function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUM function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the SUM function in Microsoft Excel is:

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

OR

SUM ( cell1:cell2, [cell3:cell4], ... )

Parameters or Arguments

number

A numeric value that you wish to sum.

cell

The range of cells that you wish to sum.

Note

• You can sum combinations of both numbers and ranges of cells using the SUM function.

Applies To

• Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Function

• Worksheet function (WS)

Example : You can also press Alt and '+' sign to get SUM using shortcuts.