Display If

Is there a function I can use to accomplish the following? --

I want to display the value in column A if the value in Column B = 0.

Thanks!

Try this

=IF(B1=0,A1,"")

How complicated can I get with this?

For example:

Can I tell Excel to display a running sum for Column B as long as Column A = X, and then have it start a new running sum in Column B as long as Column A = Y?

What I'm trying to do is find the figure displayed in Column E - Column F when the running sum value in Column B is >= to a running sum value in Column C.

Attached is a workup of what my spreadsheet would look like. But assume there are 5,000 unique Column A values.

?!?!?! Haha.

You can use the IF function to perform many formulas.

So for sums

If(A2="X", SUM(B:B),"")

or

If(A2="Y", SUM(B:B),"")

or

If(A2=8, SUM(B:B), "")

etc etc

Or you can combine them

IF(A2=8, SUM(B:B), IF(A=9, SUM(B:B), ""))

Where B:B in all cases is the range to SUM

As for your second part, again a IF will work.

=IF(B2>=C2, E2, "")

Bit harder to type without understanding how Col E and F are calculated.