Multi Column Sum and conditions

  • Thread starter Thread starter kalim
  • Start date Start date
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.
 
=SUMPRODUCT(--(rng1="Condition1"),--(rng2="Condition2"),rng3)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Sum function does recognise % 2
Add date condition 2
Returning 1 of 4 values if conditions are met 4
Conditional Formulas 5
Conditional Formatting with VBA 4
nested IF without repeating the condition? 1
Returning a value if multiple conditions are met 2
Multi-condition SUMIF 4

Back
Top