And we found it... Subtotals in the data-menu was what I was looking for. Met vriendelijke groeten, Salutations distinguées, Kind Regards,
DRIES FEYS CORPORATE SERVICES • Specialist Software Developer On 26 March 2013 15:28, Dries Feys <[email protected]> wrote: > I was too fast... > > |--A---|----B----|----C----| > |WH1| Item1 | 10 | > |WH2| Item1 | 20 | > |WH1| Item2 | 20 | > |WH3| Item2 | 10 | > |WH1| Item3 | 15 | > > Met vriendelijke groeten, Salutations distinguées, Kind Regards, > > DRIES FEYS > CORPORATE SERVICES • Specialist Software Developer > T +32 56 43 42 45 • F +32 56 43 44 46 • [email protected] > > TVH GROUP NV > Brabantstraat 15 • BE-8790 WAREGEM > T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com > > > On 26 March 2013 15:26, Dries Feys <[email protected]> wrote: >> Hello, >> >> I received today a question about a spreadsheet I can't answer >> immediately. Though I'm convinced this must be possible. >> >> We have a sheet with >> A : stock location >> B : item n° >> C : quantity >> >> The user wants now the sum per item, preferable in another sheet with >> the same layout, or in a automatically generated accumulated line. >> >> In the help I can see something about array formulas, which seems >> interesting, but I want an automatic break per item no. >> >> Example >> >> |--A---|----B----|----C----| >> |WH1| Item1 | 10 | >> |WH1| Item1 | 10 | >> |WH1| Item1 | 10 | >> |WH1| Item1 | 10 | >> |WH1| Item1 | 10 | >> >> >> Met vriendelijke groeten, Salutations distinguées, Kind Regards, >> >> DRIES FEYS >> CORPORATE SERVICES • Specialist Software Developer -- **** DISCLAIMER **** http://www.tvh.com/newen2/emaildisclaimer/default.html "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
