This beginners tutorial would explain how to perform autosum in Calc program in LibreOffice, OpenOffice.

When you are working with large spreadsheets containing huge number of rows or columns with data, it is often needed autosum with a quick click of a menu or button instead of manually typing a SUM function. LibreOffice, OpenOffice spreadsheet program Calc have this feature and here’s how you can do it.

Autosum Sigma Icon in Calc
Autosum Sigma Icon in Calc

Autosum in Calc

1. Open any Calc workbook with numbers and data, or open your own workbook.

2. Select the cell where you would like to put the autosum of your data.

3. Click on the sigma icon beside the formula bar and click Sum from the dropdown menu.

Autosum in Menu
Autosum in Menu
Autosum in Calc
Autosum in Calc

4. You can see the Sum is calculated automatically.

SEE ALSO:  Count Characters in LibreOffice Calc Cell

Tips

  • If you select multiple columns with numbers, autosum detects all the data and gives you quick sum.
  • If your data have column labels which is text, autosum ignores the same and gives you correct autosum.


For the latest tutorials, news and how-to guides, follow libreofficehelp.com on Twitter, Facebook, and subscribe to our YouTube channel and email updates via below form.

Join 515 other subscribers.