Hi Hylton, On Thu, 2011-07-28 at 21:50 +0200, Hylton Conacher (ZR1HPC) wrote:
> Hi all, > > I have a 'data' spreadsheet sheet for my family medical aid on LO 3.3.1 > with multiple columns and different information in each column. Please > see the text example I include below. > > What I would ideally like to do is have rows on sheet A, where Column D > is the same, linked onto another sheet(B). My next requirement is to > group all the like column B on sheet B, C and link them onto sheet D but > group them according to column B and SUM the amounts from sheets B, C. > > I have included a brief text example below: > > Sheet A > A B C D E > 20-July SVP SBP Robert 200 > 20-July STP SPG Hazel 100 > 21-July STP SBP Robert 180 > 22-July SVP SBP Robert 50 > 23-July STP SBP Hazel 400 > > Sheet B > A B C D E > 20-July SVP SBP Robert 200 > 21-July STP SBP Robert 180 > 22-July SVP SBP Robert 50 > > Sheet C > A B C D E > 20-July STP SPG Hazel 100 > 23-July STP SBP Hazel 400 > > Sheet D > A B C D E > STP SBP Robert 100 > STP SBP Hazel 500 > SVP SBP Robert 250 > > I have done some googling regarding row extraction and have also > investigated the SUMIF command. and whilst I can get a total of all the > STP's, I cannot SUM it by user at STP. > The SUMD command has also raised its head but I cannot figure out how to > get it to work in conjunction with SUMIF. > > Any help appreciated, even telling me MySQL is a better option. My > problem is that the data is Sheet A is ever growing and being edited by > a basic Excel user, and sheets b->D need to reflect those changes made > on sheet A. > > Again, Any Help Appreciated > -- > ======================================================================== > Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A) > http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO > ======================================================================== > If I understand your problem, you want conditionally add data based on a selection criteria from different sheets. I believe sumif works best using columns from on one sheet. I wonder if using an intermediate sheet using vlookup and sum these results might work. One issue, vlookup is to have a unique lookup parameter in the selection column. -- Jay Lozier jsloz...@gmail.com -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org 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