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



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

Attachment: ArrayFunctions.png
Description: PNG image



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