Author: Michael Crider / Source: howtogeek.com
LibreOffice Writer can handle some of the very basic tools that are part of Calc (the LibreOffice version of Microsoft Excel) with its Table function. For example, to sum up the contents of multiple cells and place the total in a new cell, you use the exact same formula, “=sum<[cellstart]:[cellfinish]>.
But what if you’re using multiple tables, and you need to insert mathematical formulas with inputs from one table and results from another? Like, say, you have a table of sales from one quarter, and a second table with sales from another quarter, and you want to combine both of those totals in a third table? Well honestly, at this point you should probably be using Calc. But if you’d rather not, it’s an easy solution.
Here’s an example of three tables in Writer. The first two tables contain sales for two separate quarters. For the third table, I want to combine the totals of the corresponding cells in the first and second table. The sum formulas in the last column will then give me the combined totals for both quarters.
The key here is a hidden property of each table: its name. LibreOffice Writer gives each table a default name in ascending order when you insert 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 specific.
First, click View > Toolbars and make sure “Table” is enabled….
The post How to Sum Numbers Across Different Tables in LibreOffice Writer appeared first on FeedBox.