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