Helpdesk Baruch College

How to Sum Numbers Across Different Tables in LibreOffice Writer

LibreOffice Writer can handle a few of the really standard tools that belong to Calc (the LibreOffice version of Microsoft Excel) with its Table function. For instance, to sum up the contents of multiple cells and position the total in a brand-new cell, you utilize the precise same formula, “=sum.

But what if you’re utilizing numerous tables, and you require to insert mathematical solutions with inputs from one table and results from another? Like, say, you have a table of sales from one quarter, and a 2nd table with sales from another quarter, and you wish to integrate both of those overalls in a 3rd table? Well honestly, at this point you should most likely be using Calc. However if you ‘d rather not, it’s a simple service.

Here’s an example of 3 tables in Writer. The first 2 tables consist of sales for two separate quarters. For the third table, I wish to integrate the totals of the matching cells in the first and 2nd table. The amount formulas in the last column will then provide me the combined totals for both quarters.

The secret here is a concealed residential or commercial property of each table: its name. LibreOffice Writer gives each table a default name in ascending order when you place the table. On this page, the tables are named Table1, Table2, and Table3. For the sake of example, let’s change those names to something more particular.

Initially, click View > > Toolbars and make certain “Table” is made it possible for. The toolbar will be docked to the bottom of the Writer window by default.

Now, click anywhere inside the very first table to make it active, and then click the “Table homes” button (the one on the far ideal) of the toolbar.

In the “Table” tab, the first home is the table name. For this example, I’m going to change the names of my 3 tables to “FirstQ,” “SecondQ,” and “Year.” Click “OKAY” to apply the modifications.

Next, decrease to the 3rd table and click cell B2. We wish to combine the worths of the B2 cells in tables FirstQ and SecondQ.

Type “=” to start a formula. Note that the cursor jumps to the formula toolbar at the top of the page.

Now you can start a formula just like any other, however you’ll have to utilize some special syntax to get in touch with cells from other tables. For any given cell, to distinguish it as a cell from another table, type the table name, a duration, and after that the cell name, and put that entire thing inside angle brackets (the less than/greater than signs). So, for instance, to insert the worth of the B2 cell from our FirstQ table, we ‘d type:

With these table differentiations, you can do anything you ‘d make with a typical cell value. Since we want to include the B2 cell values from the very first two tables together, the overall formula becomes:

Press Enter in the formula toolbar and the formula is applied to the table, providing us the total.

Here, we’ve repeated this process throughout the entire third table, adding together the values from the different cells from the very first two tables. Keep in mind that the formulas for the overalls in the fifth column still work, although those solutions (like =sum:-RRB- are only being applied to the 3rd table itself.

Keep in mind to include the table name, period, and close the worth with angle brackets, and you can use practically any offered formula while calling values from other tables. You can auto-apply the table and cell in the formula toolbar by clicking them.

Exit mobile version
Skip to toolbar