Hello Steve,
you're right, I'm on German locale, for you the ; should be , in the
formula. Try Bill's solution.
Regards
Soeren
Am 24.03.2012 20:42, schrieb greigsteve:
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
_______________________________________________
gnumeric-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnumeric-list
