At 13:52 19/03/2018 -0700, John R. Sowden wrote:
I had this working, then I noticed that it is no longer working (no
error messages). Sums any cells in col F if there is a 2211 2212 or
2213 in col M:
=SUMIF(M6:M351,"2211|2212|2213",F6:F351)
it now gives a result of zero.
That use of the "|" character to mean "or" means that your criterion
is specified by means of a regular expression. For this to work, you
need to have this facility enabled at Tools | Options... |
LibreOffice | Calc | Calculate | Enable regular expressions in
formulas. Without this, the function will match only the text
interpreted as a single fourteen-character string.
I'm guessing, but do you have this option disabled?
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
