DSUM with criteria:blank OR > some value

E

EricK

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

Mike H

Maybe this with your criteria date in C1

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
SUMIF with criteria "<>" & "=" 4
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Cumulative formula for word table 0
countifs Function not giving desired result with date criteria 2
Dsum and Dmax with structured references 1
Color a cell based on column date and row content 2
Count Blank Cells with Conditions 3

Top