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: [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
