Thread: DSUM
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sesler2 sesler2 is offline
external usenet poster
 
Posts: 7
Default DSUM

I have 4 columns in a spreadsheet:
Accepted Date, Withdrawn Date, Declined Date, $Value. In 2 cells I have
start and end dates. i.e. a67 = 01/02/2007 and b67 = 14/02/2007.

I would like to sum the $Value column if:
(Accepted Date is = a67 and <= b67) or
(Withdrawn Date is = a67 and <= b67) or
(Declined Date is = a67 and <= b67). I have tried to no success so would
greatly
appreciate some help.