SUM

The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.

Syntax

SUM(number1, number2, ….)

• number1 Required, the first number you want to add. The number can be a cell reference like B6, or a cell range like B2:B8 or constant value like 10.
• number2 Optional, This is the second number you want to add. You can specify up to 255 numbers in this way.

Specifics

• Arguments can either be numbers, arrays, or cell references that contain numbers.

Examples

• =SUM(A2:A10) Adds the values in cells A2:10.
• =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.