Sum IF-Urgent!

S

Sue

I am trying to write a formula for the following condition

I have three drop downs with values, and if any one of the values from the
drop down is selected, I have sum a column
eg: If A2 OR B2 or C2 then SUM D2:D30

ANy help is appreciated!!
 
P

Pete_UK

I think an IF - SUM is what you want. Try this:

=IF(OR(A2="condition", B2="condition",C2="condition"),sum(D2:D30),0)

Hope this helps.

Pete
 
S

Sue

It is partially correct, except that I am looking for

A OR B OR C AND E
then Sum D2:D30

and I still am not able to figure out!

Thanks!
 
P

Pete_UK

Still a bit imprecise, but try this:

=IF(AND(OR(A2="condition",
B2="condition",C2="condition"),E2="condition"),sum(D2:D30),0)

This means if any of A, B or C meet their condition AND E meets its
condition then apply the sum - I think this is what you meant.

Hope this helps.

Pete
 
Top