# SUM

## Content

This function returns the sum of cells or range of cells.

## Syntax

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

## Arguments

<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">This function has these arguments:</span>

| <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Argument</span> | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Description</span> |
| -------- | ----------- |
| <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;"> </span>*<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">number1</span>* | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">[Required] </span>The first number you want to add. The number can be like 4, a cell reference like B6, or a cell range like B2:B8. |
| <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;"> </span>*<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">[number2],...</span>* | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">[Optional] </span>This is the second number you want to add. You can specify up to 255 numbers in this way. |

## Remarks

Range references with mixed relativeness for column or row endpoints are not supported with the SUM function. R1C[1]:R2C[2] is okay but, R1C1:R2C[2] is not.
The SUM function ignores non-numeric values passed by reference. For example, if A1 contains TRUE, A2 contains "2", and A3 contains 4, then:
`TRUE+"2"+4` evaluates to 7
`A1+A2+A3` evaluates to 7
`SUM(TRUE,"2",4)` evaluates to 7
`SUM(A1,A2,A3)` evaluates to 4
The + operator provides an auto-conversion for non-numeric values passed by constant and for non-numeric values passed by reference. The SUM function provides an auto-conversion for non-numeric values passed by constant but, ignores non-numeric values passed by reference.

## Examples

`SUM(A1,B7,C11)`
`SUM(A1:A9)`
`SUM(A2:A14,B2:B18,D12:D30)`
`SUM(R1C2,R3C5,R6C2,R1C7)`
`SUM(95,89,73,87,85,76,100,96,96)` gives the result 797