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

Bill


"Pete_UK" wrote:

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" <bill wrote in message
...
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.