Have only just seen your reply Soeren due to a problem I had which I have posted as a separate thread.
I have tried the expression you suggest and also a number of variants but still cant get it to work although I can see the logic behind it. The expression you suggested was changing H2 to =sum(if(isnumber(B$2:B$300);(B$2:B$300)*($D$2:$D$300=$F2);0)) The example with the problem is : http://old.nabble.com/file/p33544690/Ignore_text_array_formula.gnumeric Ignore_text_array_formula.gnumeric Thank you, Steve -- View this message in context: http://old.nabble.com/ignore-text-in-array-formula-2-tp33544690p33544690.html Sent from the GnuMeric mailing list archive at Nabble.com. _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
