conditional summation

B

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.
 
B

Barb Reinhardt

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

The ranges should be the same size.
 
P

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
 
B

bill conlen

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

Bill
 
P

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
 
Top