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 _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
