In LibreOffice Calc an empty row/column over the entire width or height of the range indicates that the range is over, and further it's a different range. But we must remember that the range should not be interrupted. If you want to use it, go to the menu Tools → Options into section LibreOffice Calc → Calculate and set ' Automatically find columns and rows labels.' This method is useful when the range is a single column or row, but we don’t know how long will be it. 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. Last, what is the code for divide by? I want O to be N divided by some random number.In LibreOffice Calc, SUM function has the same form as in other spreadsheets such as Excel or Apache OpenOffice. I'm going to want a new formula in column N, I want it to be basically 'what percent of column L is column M?', what's the code for that? For example, column L is 100, and M is 20. I just clicked and dragged that formula to all of column M so it's not working for some reason. You can see the calculation at the top, it is =SUM(B2703:C2703:E2703:F2703) which is correct isn't it? Why in the world is it saying 711,199? I've run those numbers on a calculator twice 697,805. It's supposed to get the sum from columns B, C, E, and F. I did a simple sum calculation for column M.

I forgot to include the row, but the row with data is row 2703. I've uploaded a picture, and just below is a link to the picture. I'm a rookie, but I can't get the 'sum' feature to work?

Openoffice calc sum not working