[libreoffice-users] Re: SUMIF problem

On 16-11-2013 17:52, Mark Bourne wrote:
> John Meyer wrote:
> > =SUMIF(D1:D14,"*Landline$",F1:F14)
> >
> > Will this match any text in D1 to D14 that ends with the word "Landline"?
>
> I think you want:
>    =SUMIF(D1:D14,".*Landline$",F1:F14)
> (note the extra . before the *)
>
> In regular expressions, "." matches any character, while "*" matches any
> number (including 0) of the previous expression. So "x*" would match any
> number of "x"s, while ".*" would match any number of any character.
> LibreOffice's help contains information on other regular expression
> syntax supported.
>
> You also need to enable the option:
>    Tools > Options > LibreOffice Calc > Calculate > Enable regular
> expressions in formulae
> (otherwise SUMIF will look for the literal string ".*Landline$")
>
> Mark.

Hmm, this looks good, i did not know of the regular expression setting....

But if you do not want MyLandline in the result, you should also add a 
space ;)

".* Landline$"




--
To unsubscribe e-mail to: users+unsubscribe@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