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.

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

The ranges should be the same size.
--
HTH,
Barb Reinhardt



"bill conlen" wrote:

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.

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

Bill


"Barb Reinhardt" wrote:

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

The ranges should be the same size.
--
HTH,
Barb Reinhardt



"bill conlen" wrote:

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.

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.

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.

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

On Apr 18, 11:29*pm, bill conlen
wrote:
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.- Hide quoted text -

- Show quoted text -