Re: ignore text in array formula 2

[so09 gmx de]

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