I have 2 columns, the answer for both columns is yes or no. I want a 3rd
column to sum both of these columns according to the answer. The value for
column A is $100.00, the value for column B is $50.00, so if both columns are
€œYes€� the sum is $150.00, if just column A is €œYes€�, the sum is $100.00, if
just column B is €œYes€�, the sum is $50.00. Is that possible or should I take
another path?

Thanks

--
NotGood@All

Hello there.

Yes, this is very possible.

I'm sure someone else here can create sum super formula for you for
this, but me, I'd approach it this way...


1) Break down your work into "bits", that is, one piece at a time.
Somewhere off your viewable sheet range or outside of your print
range, setup two columns, one named 100 Mod and the other named 50 Mod
and both side by side.

2) Using this example below;

Column A Column B Column C Column X Column Y
Yes No =sum(X3:Y3) =if(A3="Yes",100,0)
=if(B3="Yes",50,0)

You can easily manage what you are trying to do when the problem is
not as "large" as it has to be.

Hope that helps!

-Imonit



On Jun 6, 3:36*pm, NotGood@All
wrote:
I have 2 columns, the answer for both columns is yes or no. *I want a 3rd
column to sum both of these columns according to the answer. *The value for
column A is $100.00, the value for column B is $50.00, so if both columns are
“Yes” the sum is $150.00, if just column A is “Yes”, the sum is $100.00, if
just column B is “Yes”, the sum is $50.00. *Is that possible or should I take
another path?

Thanks

--
NotGood@All

Assuming your data starts in Row 1, try this formula...

=100*(A1="Yes")+50*(B1="Yes")

Rick


"NotGood@All" wrote in message
...
I have 2 columns, the answer for both columns is yes or no. I want a 3rd
column to sum both of these columns according to the answer. The value
for
column A is $100.00, the value for column B is $50.00, so if both columns
are
€œYes€� the sum is $150.00, if just column A is €œYes€�, the sum is $100.00,
if
just column B is €œYes€�, the sum is $50.00. Is that possible or should I
take
another path?

Thanks

--
NotGood@All

Try this:

=(A2="Yes")*100+(B2="Yes")*50

--
Biff
Microsoft Excel MVP


"NotGood@All" wrote in message
...
I have 2 columns, the answer for both columns is yes or no. I want a 3rd
column to sum both of these columns according to the answer. The value
for
column A is $100.00, the value for column B is $50.00, so if both columns
are
"Yes" the sum is $150.00, if just column A is "Yes", the sum is $100.00,
if
just column B is "Yes", the sum is $50.00. Is that possible or should I
take
another path?

Thanks

--
NotGood@All