\<bookmark_value\>calculating;sums in text tables\</bookmark_value\>\<bookmark_value\>totals in text tables\</bookmark_value\>\<bookmark_value\>text tables;calculating sums\</bookmark_value\>\<bookmark_value\>tables;calculating sums\</bookmark_value\>\<bookmark_value\>cells;calculating sums\</bookmark_value\>\<bookmark_value\>table cells;calculating sums\</bookmark_value\>\<bookmark_value\>sums of table cell series\</bookmark_value\>

Calculating the Sum of a Series of Table Cells

  1. Choose Table - Insert Table, and insert a table with one column and more than one row into a text document.

  2. Type a number in each cell of the column, but leave the last cell in the column empty.

  3. Place the cursor in the last cell of the column, and then click the \<emph\>Sum\</emph\> icon on the \<emph\>Table Bar\</emph\>.\<br/\>The\<emph\> Formula Bar\</emph\> appears with the entry "=sum".

  4. Click in the first cell of the series you want to sum up, drag to the final cell, and then release.\<br/\>LibreOffice inserts a formula for calculating the sum of the values in the current column.

  5. Press Enter, or click \<emph\>Apply\</emph\> in the Formula bar. \<br/\>The sum of the values in the current column is entered in the cell.

If you enter a different number anywhere in the column, the sum is updated as soon as you click in the last column cell.

Similarly, you can also quickly calculate the sum of a row of numbers.

Formula Bar

Calculating in Text Documents

Calculating Complex Formulas in Text Documents

Calculating and Pasting the Result of a Formula in a Text Document

Calculating Across Tables

Please support us!