Re: sumif help

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.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]