SUM

Excel Functions

Add numbers together

Syntax

EXCEL

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

Arguments

Parameter	Description
`number1`	The first value to sum.
`number2`	[optional] The second value to sum.
`number3`	[optional] The third value to sum.

Return Value

The sum of values supplied.

Details

The SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments. The SUM function takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range. All numbers in the arguments provided are summed. The SUM function automatically ignores empty cells and text values, which makes SUM useful for summing cells that may contain text values. The SUM function will sum hardcoded values and numbers that result from formulas. If you need to sum a range and ignore existing subtotals, see the SUBTOTAL function. Typically, the SUM function is used with ranges. For example: Values in all

Examples

Typically, the SUM function is used with ranges. For example:

EXCEL

=SUM(A1:A9) // sum 9 cells in A1:A9
=SUM(A1:F1) // sum 6 cells in A1:F1
=SUM(A1:A100) // sum 100 cells in A1:A100

Examples

Values in all arguments are summed together, so the following formulas are equivalent:

EXCEL

=SUM(A1:A5)
=SUM(A1,A2,A3,A4,A5)
=SUM(A1:A3,A4:A5)

Examples

In the example shown, the formula in D12 is:

EXCEL

=SUM(D6:D10) // returns 9.05

Examples

References do not need to be next to one another. For example:

EXCEL

=SUM(A1,F13,E100)

SUM

Syntax

Arguments

Return Value

Details

Examples

See Also