Re: [libreoffice-users] SUMIF problem

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.

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