Rankif Formula

[Evan Woolley]

I am trying to rank figures based on a criteria in another column in the same row... How do I do this?

I tried to use a formula posted (by Bernie) in another thread, but it didn't work... please help!