thank you both. I checked regular expressions, and it immediately
worked. The interesting part is I would not have "unchecked" it, and it
previously worked. I wonder if there was an upgrade issue, but as for
me, now, "IT WORKS!"
thank you'
john
On 03/19/2018 01:52 PM, 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.
I tried changing the format of the searched col to text or general
number, no change
I have set the justification to 'centered'. Since the title is
greater that the width of the 4 characters,
there is a space before and after the 4 characters, but I think this
should be for display only, name changing the data.
Turning off centered justification, etc. makes no difference.
Help?
John
--
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
