OK, so I spent about 2.5 hours at work today trying to figure this out. Below is a screenshot of what my spreadsheet looks like (in reality, it's about 10,000 lines long). I want a formula in column G that will result in a zero except at each Supplier Code total (when a cell in Column A has the word "Total"). At each SC total, I want the formula to result in the corresponding Quantity. I hope this makes sense!
I've tried many different variations of formulas, including the one shown in G2, but nothing works. Can anyone help? I'm at a loss...
here's the screenshot, if it doesnt show up (http://community.webshots.com/photo/143963798/149161220neacCX) http://community.webshots.com/s/image10/6/12/20/149161220neacCX_ph.jpg

Write an IF statement and you should be all set. Use the crappy help function to get an idea of how to use the IF



R

It looks like you have entered the values in Column A as text values, throughout... The first quick fix I see would be if the word "Total" appears in the last 5 letters in the value...

If that's the case, try this:

=IF(RIGHT(A2,5)="Total",F2,0)

That says that is the 5 rightmost letters in the value are the word "Total", return the value in F2, if not, return "0".

G1K - thanks, but I spent most of those 2.5 hours working with over a dozen variations of IF formulas. Take a look at the screenshot and you'll see...

GixxPilot - You are the greatest person alive. I pledge to you my firstborn!