The **SUM** function can sum up the values in a range of cells. In this guide, we’re going to show you how to use the **SUM** function and also throw in some tips and error handling methods.

# Supported versions

- All versions

# Syntax

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

# Arguments

number1 | The first number or numbers you want to add. You can put a static number like 4, a cell reference like B6, or a cell range like B2:B8. |

[number2] | Optional. The second number or numbers you want to add up to 255 numbers. |

Examples

## Example 1

=SUM(78,84,78,109,85,100)

## Example 2

=SUM(G3,H3,I3,J3,K3,L3)

## Example 3

=SUM(G3:L3)

**SUM**function.

# Tips

- The
**SUM**function ignores the string values. However, please keep in mind that date or time values are serial numbers for Excel, not strings. - Excel's
**AutoSum**feature automatically adds the**SUM**formula by default. To apply the**SUM**function automatically:- Select the range you want to sum as well as empty cell or cells for the
**SUM** - Press
**Alt + =**(equal sign while pressing Alt key) combination

- Select the range you want to sum as well as empty cell or cells for the
- To calculate the running totals use the
**SUM**function with a*mixed reference*: How to calculate running totals in Excel Tables

# Issues

## #####

The column is too narrow for the result of the function. The solution is to increase the width of the column.

## Error

If there is an error in referred cells or ranges, the **SUM** function returns the same error.