>>> "RG" == Remy Gauthier writes:
> Hi,
> 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
> bring:
> =SUMIF(table1.$a$1:$a:20,CONCATENATE("=",final.a2),table1.$g$1:$g$20)
I think I will try this out now. Do you mean my table1
the name of the sheet, so to distribute the various tables in different
sheet our does there exits a table name (and I don't know where to find
it.) So that I could have different tables on the same sheet?
> For ResSh2, you will replace table1 with table2.
> If you want to use VLOOKUP, then you will have, for final.ResSh1:
> =VLOOKUP(final.a2,table1.$a$1:$g$20,7,FALSE())
> I hope this helps.
> Rémy.
> Le mardi 03 octobre 2023 à 18:44 +0200, Uwe Brauer a écrit :
>> Hi
>>
>> I am facing the following problem, I work with a table with 6 rows
>> but
>> 56 columns. Of course I can hide some columns but I find this not
>> very
>> comfortable.
>> So the question is can I split this table say in 8 tales, each with 7
>> columns.
>>
>> In each table the last column gives me a result of certain operation,
>> say
>>
>> #+begin_src
>> #+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
>>
>> #+end_src
>>
>>
>> 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
>> would
>> be great if this were possible.
>>
>> BTW is html mail possible/allowd on this lis?t (that would simplify
>> the
>> 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.
>> https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/
>>
>>
--
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.
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
