re: ignore text in array formula 2

[Bill <200309 scshop com>]

I do not fully understand what you are trying to do,
but this seems to work with gnumeric 1.10.16:

In column H:

=sum(if(isnumber(B$2:B$300),(B$2:B$300),0)*($D$2:$D$300=$F2))

1) check for a number,
   if true use number,
   if false use 0
2) then multiply

Simplified... this also works:

=sum(if(isnumber(B2),B2,0)*(D2=F2))

Bill