Sum

Syntax

Sum(Values1, …)

Parameters

Values1, Values2, …, ValuesN. The range of cells, for which you want to find the sum or total.

Description

It returns the sum of real numbers from the specified cell range.

Example

Formula Result Description
=Sum(B6:E6) 17,2 The sum of values within the cell range between B6 and E6. This range contains the following numbers: 12,1; -2; 4; 3,1.

See also:

Function Wizard │ Mathematical Functions │ SumSq │ SumX2MY2 │ SumX2PY2 │ SumXMY2