View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default DSUM with criteria:blank OR some value

Maybe this with your criteria date in C1

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

Mike

"EricK" wrote:

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.