Hi, it worked great! =SUMIF(A2:A7;"9|10|11";B2:B7)
I only need to sum id 9, 10 or 11. Working ok in my spreadsheet! Thanks a lot! Lic. Martin Sebastian Brilla Ghia Gerente de Desarrollos MGS Creativa - Creatividad A Tu Servicio Tel. 4509 6380 http://www.mgscreativa.com Perfil LinkedIn <http://www.linkedin.com/pub/martin-sebastian-brilla-ghia/20/326/4a0> El mar 22 nov 2011 15:18:16 ART, Regina Henschel [via Document Foundation Mail Archive] escribió: > Hi Gérard, > > I've found what is wrong in the formula. > > Gérard Fargeot schrieb: > > > =SUMIF(A2:A7,"9|10|11",B2:B7) > > > > With "Regular expressions" enabled in Tools> Options> LibreOffice Calc> > > Calculate. > > It should be not comma but semicolon as function separator. > > =SUMIF(A2:A7;"9|10|11";B2:B7) > > It is a nice way, using a regular expression. I haven't consider it > before. > > Kind regards > Regina > > > > -- > For unsubscribe instructions e-mail to: [hidden email] > </user/SendEmail.jtp?type=node&node=3528562&i=0> > 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 > > > ------------------------------------------------------------------------ > If you reply to this email, your message will be added to the > discussion below: > http://nabble.documentfoundation.org/SUMIF-on-certain-values-tp3527618p3528562.html > > > To unsubscribe from SUMIF on certain values, click here > <http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3527618&code=bWFydGluQG1nc2NyZWF0aXZhLmNvbXwzNTI3NjE4fC03NTY4NjcwOTQ=>. > NAML > <http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.InstantMailNamespace&breadcrumbs=instant+emails%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > > -- View this message in context: http://nabble.documentfoundation.org/SUMIF-on-certain-values-tp3527618p3528780.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
