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
