Re: [libreoffice-users] spreadsheet - sum one column based on the value of other

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 <boschneider@gmail.com>
To: users@global.libreoffice.org
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
jslozier@gmail.com

-- 
To unsubscribe e-mail to: users+unsubscribe@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