Bruno, Assuming the headers are in row A and the data is in columns 1 thru use:
=sumid(c2:c5,food) -----Original Message----- From: Bruno Schneider <[email protected]> To: [email protected] Subject: [libreoffice-users] spreadsheet - sum one column based on the value of other Date: Sun, 8 Sep 2013 12:58:03 -0300 I have a spreadsheet with values that are categorized, for instance: Name - Category - Value lunch - food - 20 fuel - transportation - 100 dinner - food - 20 repairs - transportation - 200 Then I would like to have a sum of values for each category, such as: food - 40 transportation - 300 Can anyone help with functions to make this "per category sum"? -- Bruno Schneider -- Jay Lozier [email protected] -- 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
