And, for 2 criteria like this:
=SUMPRODUCT((YEAR(A1:A50)=2011)*(B1:B50="ZZZ"))
On Sat, Oct 8, 2016 at 9:38 PM, m.a.riosv
wrote:
> Or
>
> =SUMPRODUCT(YEAR(A1:A50)=2011)
>
> Miguel Ángel.
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/
> COUNTIFS-with-cells-of-
2016-10-08 4:03 GMT+02:00 Tim---Kracked_P_P---webmaster <
webmas...@krackedpress.com>:
>
>
> 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/
At 18:01 06/10/2016 -0400, Doug McNutt wrote:
Brian had some questions about how I read, with curl and perl5, the
csv files which seemed to be applying an apostrophe to dates
formatted as MM/DD/.
I'm not sure why you think you need to preprocess these documents
before using them. It would
Hi there,
I'd like to file serious complaints about Libre Office.
A. The downloads
We've been users for several years of Open Office. When Libre Office
started as a fork, we decided it was a wise thing to go on with Libre
Office. We don't had any complaint about it until version 5.1.5 It
was
At 18:05 08/10/2016 +, Julio Cesar Campos wrote:
2016-10-06 2:45 GMT+00:00 Brian Barker:
At 22:14 05/10/2016 +, Julio Cesar Campos wrote:
Whenever corrects spelling, the text is put in this way and is
very cumbersome back to the original form, I have not found how to
disable this optio
At 08:53 09/10/2016 -0400, Bruce Hohl wrote:
And, for 2 criteria like this: =SUMPRODUCT((YEAR(A1:A50)=2011)*(B1:B50="ZZZ"))
Except that this - though it will work - is missing the point of
SUMPRODUCT(). That multiplication sign is unnecessary. It's a bit
like using =SUM(A1+A2) (which will als
I just downloaded LO 5.2.2.2 for Windows from LibreOffice.org using Firefox
and installed on my Windows 7 (64 bit) notebook without problem. The
program opens and appears to work correctly.
On Sun, Oct 9, 2016 at 12:23 PM, Jurriaan Nijkerk
wrote:
> Hi there,
>
> I'd like to file serious complai