Translations:Documentation/Calc Functions/SUM/17/en
Formula | Description | Returns |
---|---|---|
=SUM(2;3;4) | sums up 2,3,4 | 9 |
=SUM(A1;A3;B5) where A1,A3,B5 have 2,3,4, respectively | calculates the sum of the three cells | 9 |
=SUM (A1:A5) where A!to A5 cell contains 2,3,4,5,6 | calculates the sum of all cells in the A1 to A5 cell range | 20 |
=SUM (A1:A5) where A!to A5 cell contains 2,3,4,5,6 | calculates the sum of all cells in the A1 to A5 cell range | 20 |