Hi :) !! Blimey!! Nicely done :D Congrats and regards from Tom :)
>________________________________ > From: Dries Feys <[email protected]> >To: "[email protected]" <[email protected]> >Sent: Tuesday, 26 March 2013, 14:44 >Subject: [libreoffice-users] Re: question with selective sums > >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 > > > -- 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
