Date: prev next · Thread: first prev next last
2023 Archives by date, by thread · List index


You can use the SUMIF function to have the ResSh1 and ResSh2 of final
to be updated each time you make an entry. If you only have one "Smith"
per table, you can use VLOOKUP to fetch the $7 value for Smith. You
will use these functions to find the "Smith" values in each of your
smaller tables.

Assuming "Name" of table1 is in A1, "Smith" of final is in A2, and
there are 20 rows in table1, using SUMIF for the ResSh1 in final would


For ResSh2, you will replace table1 with table2.

If you want to use VLOOKUP, then you will have, for final.ResSh1:


I hope this helps.

Le mardi 03 octobre 2023 à 18:44 +0200, Uwe Brauer a écrit :

I am facing the following problem, I work with a table with 6 rows
56 columns. Of course I can hide some columns but I find this not
So the question is can I split this table say in 8 tales, each with 7

In each table the last column gives me a result of certain operation,

#+Name: table1
Name  | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh1 |
Smith |   2 |   3 |   4 |   6 |   7 | 22     |
#+TBLFM: $7=vsum($2..$6);f2

#+Name: table2
Name  | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh2  |
Smith |   1 |   3 |   5 |   8 |   9 |     26 |
#+TBLFM: $7=vsum($2..$6);f2

#+Name: final
Name  | ResSh1 | ResSh2 | Total |
smith |     22 |     26 | 48    |
#+TBLFM: $4=vsum($2..$3);f2


So that every time I actualise any column in any table, that
table gets updated and the final one

Is this possible. It is possible in emacs org mode with its table
spreadsheet, however my colleagues use either LO or Excel, so it
be great if this were possible.

BTW is html mail possible/allowd on this lis?t (that would simplify
display of my tables)

Thanks and regards

Uwe Brauer 

Warning: Content may be disturbing to some audiences
I strongly condemn Putin's war of aggression against Ukraine.
I support to deliver weapons to Ukraine's military. 
I support the NATO membership of Ukraine.
I support the EU membership of Ukraine.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.