Rank cells on one sheet and have that result fill cell on another sheet

Hi All! I am trying to use the RANK formula. What I would like to happen is to rank 5 cells that are filled with numbers on one sheet (titled: Results) and have that result fill in a cell on another sheet (titled: 5teams). I tried a formula like this - =RANK(Results!B3, Results!B3:F3). When I try this i get #N/A. Can someone help me figure out what I am doing wrong?


Thanks!!
Claire

I actually figured it out. Sorry about that! I had the information entered in as text and not a number on the Results sheet. Thanks!!