Sum of Columns

[NotGood@All]

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

 

[Imonit]

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

 

[Rick Rothstein \(MVP - VB\)]

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

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

Rick

 

[T. Valko]

Try this:

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