Translations:Documentation/Calc Functions/SUM/17/en

From The Document Foundation Wiki
Jump to: navigation, search
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