I'm trying to get the top ten ranking locations based on the sum of
the sales. The real list is 1000s of entries so here is an example of
what it looks like:

Location # Sales
1 10
2 20
2 10
2 30
3 50
4 200
4 10
5 20
6 10
6 100
6 20
7 10

The end result would look like this:
4 210
6 130
2 60
3 50
5 20
1 10
7 10

How do I do this in a systematic way with a formula? Thanks for your
help in advance.