Never mind, found the solution. Soeren
Am 06.12.2011 10:57, schrieb s...@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
_______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
