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



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




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