Re: DMEDIAN function / Re: [Bug 665308] DMEDIAN function

On Tue, 2011-12-06 at 10:57 +0100, so09 gmx de wrote:
Dear Andreas, all,

your solution (emails, 
does not generally work. It only works for special cases.

"Multiple conditions can be combined using the AND or OR functions as in 
median(if(OR(A1:A20="AA",A1:A20="BB"),B1:B20))." Yes and no. These 
multiple conditions refer to one value only, namely the one in column A. 
For multiple conditions regarding more than one value/column, this does 
not work; see attached screenshot. (If I have it wrong, please correct 
me. I did not find a solution in the documentation for Gnumeric or 

Is there a solution using array funtions, or is this only possible with 
database functions like daverage?


Thanks Soeren for pointing this out. In the context of array evaluation
OR (and AND) is applied to all 40 equality tests here. One would need to
use multiplication and addition for AND and OR respectively. I will fix
the documentation.


Andreas Guelzow <aguelzow pyrshep ca>

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]