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