Multi Column Sum and conditions

K

kalim

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.
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Top