I think you are making heavy weather of this. If the criterion is equality, it does not need to be mentioned: you need just to indicate the cell containing the relevant value. Try:
> =SUMIF(A1:A10;X2;B1:B10) > Since you need to fill this down the Y column, you will need to freeze the > row references to A and B, of course: > =SUMIF(A$1:A$10;X2;B$1:B$10) > > I trust this helps. > > Brian Barker > > Thank you, it works! /Klaus -- Klaus F. Østergaard, <farremosen(at)gmail dot com> -- 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
