How To Do AutoSum in LibreOffice Calc?

Published in

on

AutoSum in LibreOffice Calc

To perform an AutoSum in LibreOffice Calc, follow these steps:

  1. Select the cell where you want the sum to appear.
  2. Click on the AutoSum (∑) button located in the toolbar. If it’s not visible, you can find it under Sheet > Sum from the menu.
  3. LibreOffice Calc will automatically select a range of cells above or to the left of the current cell (depending on where the data is). Verify the range of cells that it highlights. If it’s not selecting the correct range, you can adjust the range manually by dragging over the desired cells.
  4. Press Enter to apply the formula.
  5. This will calculate the sum of the selected range and display the result in the chosen cell. Do the bold and highlight the total if needed.

You can also use the =SUM() formula manually, where you specify the range inside the parentheses, like this:

=SUM(A1:A10)

This would sum up the values from cells A1 through A10.

Leave a Reply

Your email address will not be published. Required fields are marked *