ignore text in array formula 2

[greigsteve <greigsteve gmail com>]

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.