Try this:

Assume:

A2:A20 = Accepted Date
B2:B20 = Withdrawn Date
C2:C20 = Declined Date
D2:D20 = $Value
A67 = 01/02/2007
B67 = 14/02/2007

=SUMPRODUCT(--(MMULT((A2:C20=A67)*(A2:C20<=B67),{1;1;1})0),D2: D20)

Biff

"sesler2" wrote in message
...
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.