On Tue, 22 Nov 2011, Regina Henschel wrote:
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)
If I use semicolons, LibreOffice changes them to comma's again. But it
does work with comma's here. Maybe this is related to locale ?
It is a nice way, using a regular expression. I haven't consider it before.
Indeed :) Very useful ! Thanks !
--
-- dag wieers, [email protected], http://dag.wieers.com/
-- dagit linux solutions, [email protected], http://dagit.net/
[Any errors in spelling, tact or fact are transmission errors]
--
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
