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
