Urmas - davian...@gmail.com wrote:
05.11.2015 23:19, Tom Davies:
For some weird reason IE decided to
rename the downloads from ".msi" to another format.
That 'weird reason' was the error in the default webserver configuration
which no one of LO people cared to fix.
When that problem
05.11.2015 23:19, Tom Davies:
> For some weird reason IE decided to
> rename the downloads from ".msi" to another format.
That 'weird reason' was the error in the default webserver configuration
which no one of LO people cared to fix.
--
To unsubscribe e-mail to:
I have two columns of data, A and B. Sometimes A.n>B.n, A.nA.n=B.n. I want to count these occurrences. The closest I could find
in help was countif(), but that doesn't really do what I need. Any ideas?
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
I think I found it.
In A1:B1 enter your values. It doesn't matter if not all rows are
filled.
Enter the following in the following cells:
C1: A>B
C2: A=B
C3: AB1:B1)*(ISNUMBER(A1:A1))*(ISNUMBER(B1:B1)))
D2: =SUM((A1:A1=B1:B1)*(ISNUMBER(A1:A1))*(ISNUMBER(B1:B1)))
I think for not take care of the number of blank cells, it's easier and
versatile with SUMPRODUCT()
=SUMPRODUCT($A$2:$A$12>$B$2:$B$12;$A$2:$A$12>0;$B$2:$B$12>0)
Attached a sample file.
Miguel Ángel.
--
View this message in context:
