Re: [libreoffice-users] Problem with the sumif function

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

Re: [libreoffice-users] Problem with the sumif function

2018-03-19 22:48 GMT+01:00 Johnny Rosenberg : > 2018-03-19 21:52 GMT+01:00 John R. Sowden : > >> 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

Re: [libreoffice-users] Problem with the sumif function

2018-03-19 21:52 GMT+01:00 John R. Sowden : > 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) > Are you sure this

Re: [libreoffice-users] Problem with the sumif function

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

Re: [libreoffice-users] need some help with custom number format code

At 20:12 19/03/2018 +0100, Albert Oszkó wrote: Thank you very much for this short tutorial! No probs! These codes are for numbering documents. The first part - in this case AB or AB - refer to the type of the course these documents belong to. 01 etc are serial numbers from 01 to -say- 60.

[libreoffice-users] Problem with the sumif function

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

Re: [libreoffice-users] need some help with custom number format code

2018-03-19 19:33 keltezéssel, Brian Barker írta: At 15:06 19/03/2018 +0100, Oszkó Albert wrote: I would like to create a custom number format code in Calc, to spare some work. This would be like this AB-01/2018. I would like to increment only the 01 part by dragging that little rectangle on

Re: [libreoffice-users] need some help with custom number format code

At 15:06 19/03/2018 +0100, Oszkó Albert wrote: I would like to create a custom number format code in Calc, to spare some work. This would be like this AB-01/2018. I would like to increment only the 01 part by dragging that little rectangle on the lower right of the cell. So I created as

[libreoffice-users] need some help with custom number format code

Hi all, I would like to create a custom number format code in Calc, to spare some work. This would be like this AB-01/2018. I would like to increment only the 01 part by dragging that little rectangle on the lower right of the cell. So I created as custom formats "AB-"##"/2018" or