Re: sumif help

[Tino Meinen <a t meinen chello nl>]

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