Hi, razor7 wrote
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"
=SUMIF(A2:A7,"9|10|11",B2:B7) With "Regular expressions" enabled in Tools > Options > LibreOffice Calc > Calculate. Gérard -- View this message in context: http://nabble.documentfoundation.org/SUMIF-on-certain-values-tp3527618p3527665.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