Re: Ignore text in array formula

[so09 gmx de]

Hello Steve,

changing H2 to
=sum(if(isnumber(B$2:B$300);(B$2:B$300)*($D$2:$D$300=$F2);0))
or something along those lines works.

Regards
Soeren


Am 22.03.2012 17:30, schrieb greigsteve:
> I would like to be able to use a sum array formula but still be able to put
> text in some of the cells in the column to be summed. I have attached a file
> with a simplified example of what I am trying to do. Hope you can help,
> http://old.nabble.com/file/p33544632/Ignore_text_array_formula.gnumeric
> Ignore_text_array_formula.gnumeric Steve