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