Conditional Calculation

[Wet_Blanket]

I am looking for a excel formula to accomplish the following.

Column A Column B
$500
$750 X
$100 X

Can someone give me a formula that calculates the sum of Column A where there is an x in Column B?

 

[Mr. B]

Take a look at the SUMIF function. It will do what you want.
Here is the formula:

=SUMIF(B3:B5,"=x",A3:A5)

 

[Wet_Blanket]

Thank you Mr. B! Final question, what would I do if I wanted a sum for everything that does not have an "x"?

 

[Mr. B]

Just change the = to <> in the formula.

 

[Wet_Blanket]

You are awesome Mr. B!

 

[Mr. B]

Glad to help. Good luck with your project.