Ranking conditional groups... but negative figures...

I need help guys

I'm trying to rank items in a table in multiple groupings (see attached file).

I need to rank the store number (1751 etc) in ranking order of area (R1-A1), as well as region separately (which I'm sure I can do once someone helps me with ranking by area!)

I think I'm getting stuck because of the negative values I'm trying to rank.

Any help would be greatly greatly appreciated