DSUM with criteria:blank OR

DSUM with criteria:blank OR > some value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EricK - 04 Jul 2009 12:07 GMT

Cells in Column A, headed "date" are either blank or contain dates; cells in
column B, headed "Amount", contain a number.

I want to sum, using DSUM, cells in column B, where the corresponding cell
in column A is either blank or contains a date after a certain date. But
however I set up the criteria table, it doesn't seem to work.

Reply to this Message

Mike H - 04 Jul 2009 13:28 GMT

Maybe this with your criteria date in C1

=SUMIF(A2:A20,"",B2:B20)+SUMIF(A2:A20,">"&C1,B2:B20)

Mike

> Cells in Column A, headed "date" are either blank or contain dates; cells in
> column B, headed "Amount", contain a number.
>
> I want to sum, using DSUM, cells in column B, where the corresponding cell
> in column A is either blank or contains a date after a certain date. But
> however I set up the criteria table, it doesn't seem to work.

Reply to this Message

Ashish Mathur - 06 Jul 2009 04:10 GMT

Hi,

Give us an example of your data layout, the criteria and the DSUM formula
which are you using

Signature

Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

> Cells in Column A, headed "date" are either blank or contain dates; cells
> in
[quoted text clipped - 3 lines]
> in column A is either blank or contains a date after a certain date. But
> however I set up the criteria table, it doesn't seem to work.

Reply to this Message