software

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 D230

ANy help is appreciated!!

=sumif(a2,quot;enter text from dropdownquot;,d2:d30)

--
--Chip Smith--
MVP Wannabe quot;Suequot; wrote:

gt; I am trying to write a formula for the following condition
gt;
gt; I have three drop downs with values, and if any one of the values from the
gt; drop down is selected, I have sum a column
gt; eg: If A2 OR B2 or C2 then SUM D230
gt;
gt; ANy help is appreciated!!

A2,b2,C2 are values in the Dropdowns

quot;Chip Smithquot; wrote:

gt; =sumif(a2,quot;enter text from dropdownquot;,d2:d30)
gt;
gt; --
gt; --Chip Smith--
gt; MVP Wannabe
gt;
gt;
gt; quot;Suequot; wrote:
gt;
gt; gt; I am trying to write a formula for the following condition
gt; gt;
gt; gt; I have three drop downs with values, and if any one of the values from the
gt; gt; drop down is selected, I have sum a column
gt; gt; eg: If A2 OR B2 or C2 then SUM D230
gt; gt;
gt; gt; ANy help is appreciated!!

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

=IF(OR(A2=quot;conditionquot;, B2=quot;conditionquot;,C2=quot;conditionquot;),sum(D230),0)

Hope this helps.

PeteIt is partially correct, except that I am looking for

A OR B OR C AND E
then Sum D230

and I still am not able to figure out!

Thanks!

quot;Pete_UKquot; wrote:

gt; I think an IF - SUM is what you want. Try this:
gt;
gt; =IF(OR(A2=quot;conditionquot;, B2=quot;conditionquot;,C2=quot;conditionquot;),sum(D230),0)
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;

Still a bit imprecise, but try this:

=IF(AND(OR(A2=quot;conditionquot;,
B2=quot;conditionquot;,C2=quot;conditionquot;),E2=quot;conditionquot;),sum (D230),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