# Difference between revisions of "Documentation/How Tos/Calc: SUM function"

From Apache OpenOffice Wiki

< Documentation | How Tos

m |
|||

Line 31: | Line 31: | ||

'''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]''' | '''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]''' | ||

+ | [[fr:Documentation/FR/Calc:Fonction SOMME]] |

## Revision as of 21:12, 27 March 2008

## SUM

Sums the contents of cells.

### Syntax:

**SUM(number1; number2; ... number30)**

` number1` to

`are up to 30 numbers or ranges of numbers whose sum is to be calculated.`

**number30**` SUM` can also be used to sum cells where a specified condition is true - see

**Conditional Counting and Summation**.

### Example:

**SUM(2; 3; 4)**

- returns
, because**9**+**2**+**3**=**4**.**9**

**SUM(B1:B3)**

- (where cells
,**B1**,**B2**contain**B3**,**1.1**,**2.2**) returns**3.3**.**6.6**

### See also:

**SUBTOTAL function**,
**DSUM function**,
**SUMIF function**,
**SUMSQ function**,
**SUMPRODUCT function**