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

[so09 gmx de]

Never mind, found the solution.

Soeren


Am 06.12.2011 10:57, schrieb so09 gmx de:
> Dear Andreas, all,
>
> your solution (emails,
> "http://projects.gnome.org/gnumeric/doc/sect-data-formulas.shtml#sect-data-formulas-database";)
> 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
> LibreOffice.)
>
> Is there a solution using array funtions, or is this only possible with
> database functions like daverage?
>
> Soeren