Rank of Wins/Losses

Morning,

I am trying to create a ranking of Wins and Losses for different companies in our portfolio. I've attached an example. In my original worksheet, Columns C-G have countif formulas attached to them.

Columns H and I are the ones I'm having issues with in terms of Ranking the order of RFPs and Wins.

When I try to sort in my spreadsheet, it moves everything all around and in to incorrect cells, rankings, etc. However, when I "killed" the columns C-G formulas, the rankings worked fine (i.e - my attached excel sheet).

Can I rank columns H and I, if I have formulas in other columns?

Thanks,

Hello,

I am not understanding how the rankings work but I mocked up a slightly different scenario based on wins and losses percentage rankings.

I hope this helps

I wasn't sure if this was what the user wanted. I will not offer my assistance further since my type of help has not been appropriate.

Sincerely,
CE

Thank you for the response, however, in my spreadsheet I have formulas (I can't show those in here as they wouldn't transfer). I need to be able to sort Columns J and K. Is this not happening accurately because I have active formulas looking into other sheets, or are there other reasons?

Thanks in advance.

rO