Hi, i'm trying to calculate sum of a column on certain values of other column. I want to sum all the values from column "value" only if corresponding "id" column value is "9, 10 or 11". My SUMIF functin looks like this *=SUMIF(D2:D187;"9,10,11";E2:E187)* where D2 is "id" column and E2 is "value" column. So far i get 0 as SUMIF result but result may be "180" id value 5 2,09 15 2,09 15 2,09 11 100 9 5 10 75 Please advise! Thanks a lot! -- View this message in context: http://nabble.documentfoundation.org/SUMIF-on-certain-values-tp3527618p3527618.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@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