This method I see even less, perhaps because it is disabled by default. Now it is possible to type the range name in the function as an argument instead selecting a range by the mouse.Īnother way is to use the column headers or row: Do not forget to remove or put on them respective your situation. Pay attention to flags ' Contains column labels' and ' Contains totals row', the first of which is set by default. In the field Name, type a new range name. Select the range of cells, go to the menu Data→ Define Range. The third way I see very rarely, but it is often convenient. The formula will determine the rectangle of the range and calculate the sum. In this case, we specify the first (the top left) and last (the bottom right) cells in the range.

The function will 'take out' the numerical value and add up it. ) can be as cell references (A1 C6 AZ190), and can be mixed (1 A1 C6 3). Listings of numbers can be explicit (1, 2, 3. In this case, we just list numbers with the semicolon. In LibreOffice Calc, SUM function has the same form as in other spreadsheets such as Excel or Apache OpenOffice.

Openoffice calc recalculate