[libreoffice-users] Re: SUMIF on certain values

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