Op di, 24-05-2005 te 15:10 +0300, schreef Ain Vagula: > I'd recommend using array formulas with function SUM as sum of products, > where > first member of product is cell value, second member result of condition (0 > or 1). Then by summing values, that do not satisfy condition, are 0.
For something like this you could put: =if( isblank(B1), A1, 0 ) in an extra column for the whole range and sum those values, though Andreas' method is more elegant and straightforeward, it fails if one of the values in column B is a negative number. Tino _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
