How to Calculate Sums in LibreOffice Writer Tables

LibreOffice Writer includes built-in calculation capabilities that allow you to compute mathematical sums directly within your text tables without needing to switch to LibreOffice Calc. This guide explains how to use the Formula bar, cell coordinates, and the Sum tool to calculate totals across rows and columns quickly and efficiently.

Understanding Table Coordinates

LibreOffice Writer tables use the standard spreadsheet coordinate system: * Columns are labeled alphabetically from left to right (A, B, C…). * Rows are numbered sequentially from top to bottom (1, 2, 3…). * The top-left cell is A1, the cell to its right is B1, and the cell below it is A2.

Method 1: Using the AutoSum Feature

  1. Place your cursor in the empty cell where you want the total to appear (typically directly below a column of numbers or at the end of a row).
  2. Click the Sum (\(\Sigma\)) icon located on the Table toolbar, or press F2 on your keyboard to open the Formula Bar.
  3. Writer automatically highlights the adjacent numbers and enters the formula (for example, =sum <A1:A5>).
  4. If the selected range is correct, press Enter or click the green checkmark on the Formula Bar to display the sum.

Method 2: Entering Sum Formulas Manually

  1. Click the cell where the calculation result should be placed.

  2. Press F2 or type an equals sign (=) to activate the Formula Bar at the top of the workspace.

  3. Type the sum function:

    =sum <A1:A5>

    (Note: Writer formulas require cell coordinates to be enclosed in angle brackets < >)

  4. Alternatively, type =sum and then click and drag your mouse across the target cells to automatically populate the range.

  5. Press Enter to apply the formula.

How to Recalculate and Update Sums

LibreOffice Writer does not automatically recalculate formulas when you change numbers in the table. To refresh your totals: * Select the table or the specific cell and press F9. * Alternatively, go to the top menu and select Tools > Update > Fields.

Formatting the Number Output

To format the sum result as currency, percentages, or specific decimal places: 1. Right-click the cell containing the calculated sum. 2. Select Number Format from the context menu. 3. Choose the desired category (such as Currency or Number) and adjust decimal precision as needed. 4. Click OK to apply the formatting.