[libreoffice-users] Re: COUNTIFS with cells of yyyy-mm-dd

Or =SUMPRODUCT(YEAR(A1:A50)=2011) Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/COUNTIFS-with-cells-of--mm-dd-tp4195901p4196282.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

Re: [libreoffice-users] COUNTIFS with cells of yyyy-mm-dd

thank you all for your replies ... using your suggestions following will do what I wanted to accomplish: =COUNTIFS(A10:A500,">="(2016,1,1),A10:A500,"<="(2016,12,31),F10:F500,"="&"ZZZ") and I have another cell with the above using 'SUMIFS' instead , therfeore, working on data in three

Re: [libreoffice-users] error installing LO 5.2.2

On 10/08/2016 01:28 AM, Michael D. Setzer II wrote: I just removed 5.2.0 and tried to install 5.2.2. Below is the error message I received. I do not know what dependencies are needed for 5.2.2 that was not for 5.2.0? Any Idea? I run Ubuntu/Mate 16.04 64-bit. I've had the same issue for

Re: [libreoffice-users] Change Tracking Writer

Thanks Brian for your reply, my question goes beyond, is there any way to disable change tracking is a very troublesome option and not use it for anything. 2016-10-06 2:45 GMT+00:00 Brian Barker : > At 22:14 05/10/2016 +, Julio Cesar Campos wrote: > >> Whenever

Re: [libreoffice-users] Drawing electrical symbols

Hi Martin, Martin Marmsoler schrieb: Hello, sorry for the late response, I didn't get the email. No, I wouldn't like to draw a electrical schematic for creating a pcb like KiCad, Eagle I would like to draw pictures for my bachelor thesis. In draw it's easier to draw arrows, change color

[libreoffice-users] Drawing electrical symbols

Hello, sorry for the late response, I didn't get the email. No, I wouldn't like to draw a electrical schematic for creating a pcb like KiCad, Eagle I would like to draw pictures for my bachelor thesis. In draw it's easier to draw arrows, change color of paths and some other nice things. It