conditional summation

[bill conlen]

I would like to add the values from all rows in a column that are empty in a
different column; i.e, leave out the values that have a 'sell date'.

This must be pretty simple, but I would appreciate some help. Thanks.

 

[Barb Reinhardt]

=SUMPRODUCT(--(ISBLANK(SellDateRange)),(SumRange))

The ranges should be the same size.

 

[Pete_UK]

Try this:

=SUMIF(sell_date_range,"<>",Value_range)

Put the appropriate ranges in to suit your data, e.g. A:A, or B:B, as you
can use full-column references with SUMIF.

Hope this helps.

Pete

 

[bill conlen]

Thanks, Barb, that did the trick, although I can't say I understand it.

Bill

 

[bill conlen]

Thanks, Pete. This gives the desired results if I change the "<>" to "=".
Can't say I understand why.

Bill

 

[Pete_UK]

Sorry. I've just read your first post and you did ask to add up values
where the sell-date was empty - I gave you the version for sell-date
not being empty.

Excel Help describes the SUMIF function quite well.

Pete