Hi,

I have been trying to sum from a column after it meets three conditions. I
have tried three things now and I can't get any of them to work.

The first thing I tried was to take it through a conditional sum wizard, and
my formula looks like this:

=SUM(IF($A$3:$A$55="S",IF($C$3:$C$55=-12.5,IF($D$3:$D$55="SEP06MAR07",$B$3:$B$55,0),0),0 ))

What I would like for it to do is add the value from column c only when the
same row value in column b is "S", when column d is "SEP06MAR07", and when
column C is -12.5, but for some reason it's not working.

Then I tried to make it myself with:

=SUM(IF(($A$3:$A$55=I$2)*($C$3:$C$55=$G4)*($D$3:$D $55=$G$2),$B$3:$B$55,0))

where I$2 = S, $G4 = -12.5, and $G$2 = SEP06MAR07.
I think that because the first row in the database satisfies these
conditions, it is summing up the entire column b.

I have also tried to use the DSUM method:

=DSUM(A2:D55,"QUAN",G6:I7)

Where "QUAN" serves as the title for the column I would like to be summed
and G6:17 looks like:

B/S PRICE TYPE
S -12.5 =SEP06MAR07

I have tried all 3 and I can't seem to get any of them to work. Any help you
can give me?

Thanks,
Darren