Multi Column Sum and conditions

Hi,

I have 5 sets and each set has the following

- Condition 1
- Condition 2
- Amount

Both the conditions can appear in any of the 5 sets. Which formula I could use to sum the Amount column based on the conditions?

I tried DSUM but I could only evalute one set not all the 5 and same is the case of ConditionalSUM Wizard.

=SUMPRODUCT(--(rng1="Condition1"),--(rng2="Condition2"),rng3)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"kalim" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I have 5 sets and each set has the following
>
> - Condition 1
> - Condition 2
> - Amount
>
> Both the conditions can appear in any of the 5 sets. Which formula I
> could use to sum the Amount column based on the conditions?
>
> I tried DSUM but I could only evalute one set not all the 5 and same is
> the case of ConditionalSUM Wizard.
>
>
> --
> kalim
> ------------------------------------------------------------------------
> kalim's Profile:
http://www.excelforum.com/member.php...o&userid=34700
> View this thread: http://www.excelforum.com/showthread...hreadid=544667
>