> One way to do this is to put in F1: > =SUMIF(B2:B5;E1;C2:C5) > > If instead you put: > =SUMIF(B$2:B$5;E1;C$2:C$5) > you can even fill it down column F into F2, giving > =SUMIF(B$2:B$5;E2;C$2:C$5) > > Another technique is to put in F1: > =SUMPRODUCT(B2:B5=E1;C2:C5) > or, again, > =SUMPRODUCT(B$2:B$5=E1;C$2:C$5) > so you can fill this down into F2. >
That solves it. Thank you. -- Bruno Schneider -- To unsubscribe 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
